Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dynamic Filters on Dimension and Measures

Hi All, I want to display the diimension and their measures based on selection in the Table Visual. Like below Delivery Type, Brand, Manufacturer .... Materials these all are dimenssions and SKUs,...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

unfortuantely i don';t think switch will work on this, and I also thing selectedvalue is going to work , I just gave you an idea, selectedvalue only works if user select one value in the slicer.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Instead of selectedvalue you need to check following and that will take care if use selected more than one value in slicer:

 

if("Delivery Option" IN VALUES(TableDimension[DimensionName]), Table[Delivery Option], BLANK())