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
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()) Created a below column
SelectedDim = IF(SELECTEDVALUE('Dimensions'[Dimensions])="Delivery Type",KPI_Sales[Delivery Type],"NUll")
when I select Delivbery Type in slicer below it still does not refletc Delivery Type with its values form main table.
It seems Selected Value is not working for single value too.
Thanks
- parry2k
please add it as measure