Forum Discussion
Dynamic Filters on Dimension and Measures
Super UserI don;t think it is possible but here is hack to do it but will not very pretty
Here is high level how you can do it:
1. Add two tables with Dimension and Measures name in it.
2. Put these as field as slicer
3. Each of your dimension and measure will have if condition , for example "Deliver Type" dimension will be condition like
Delivery Type = IF(SelectedValue(TableDimension[DimensionName]) = "Delivery Type", Table[Delivery Type], BLANK()). You have to do it for every dimension/measure
4. Add table visual, drop all dimension/measures in table
Based on value selected in the slicer, you will see only selected dimension/measures values will show up in Table, and others will be blank.
Here is why it will not look pretty:
1. Header for all dimension/measures will be always visible.
2. All the columns in table will not be next to each other, so there will be gap in the table depending
Thanks,
P
Great let me try and get back on this
Can isue Swicth in stead of if so that I can do it in single siwtch statement like blow:
SWITCH(SelectedValue(TableDimension[DimensionName]), "Delivery Type", Table[Delivery Type],and so on
- parry2k
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
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())