selected Product category, subcategory, container and product name with relevant filters option....
next when i select one more product category it is not displaying again when i select all option it is working
that is because when you select Furniture, there will be very few sub-categories related to Furniture. so when you select other sub-categories which are related to Furniture the data wont get filtered because already Furniture is one level above sub category so already the data got filtered so even if you select them under sub-category there wont be any changes in the data.
when you hover the filter you will see four horizontal lines to show fewer values you can select that option try filtering the data you will get to know why the data behavior.
please select all the filters as only relevant values only. product category filter use all values. i checked your workbook. you have used only relevant values in subcategory only.
when i select Product category = Technology and others options in every filter, its working well (i have set all filters as relevent)
now again when i select Product category =Furniture then why is it not displaying
hi jessy,
you used the single value filter option in product name, now change product name as multiple value list then it show
Jessy you need to know about hierarchies in the data, which is the higher level and which is lower level, if you have selected one higher level then even if you the select the next level data, the data wont get filtered. so please know the level's of each filter you have used then you will understand why the data is behaving the way you see now
but venkat, am selecting other value from higher level called product category they doesnt it display all relevant data in other below levels ?
if my requirment is to display in hierarchy levels do i have to always select al button in all the levels ?
because if i select "All" option every time then only it is allowing me to select options from product category level..
how to over come this ? is ther any other way ?
Hi Jessy, Can you please send me the twbx file which you have already selected and what you want to select so that i can see your problem, so that we will get to know whether the issue is really with tableau or from our side.
sankar , i am unable to open your work book..
Vekat i attached book
Hi Jessy
You've made your selection in the filters: Technology, Computer Peripherals, Small Box, Acco Keyboard. You will notice that these filters show on the filter card:
However, when you add Furniture you have identified that no other products show up in your list. The reason is that your selection of Furniture only effects the Product Category filter. All the other filters remain:
As there are no furniture products which meet those criteria, nothing extra is shown. You will need to reset the filters (initially change them back to All) for sub-category, container and name for additional products to show up in your list. You can then make another choice.
Best Wishes
Juliette
Thank you juliette....so i came to conclusion that in tableau you need to always reset filters to go for next level selection and there is no direct way.