Forum Discussion
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, SKUs LY,SKUs YoY,Sales,Sales LY and so on are measures.
I want to have above filters where user can select whatever dimensions and measures they want to see in Table Visual.
For Ex :- If user selects Dimenssion Delivery Type and measures SKUs, SKUs YoY so only these 3 fields should display in tabel visual.
Kindly help, please note the dimensions and measures are from same query.
21 Replies
- parry2k
Super User
I 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
- 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.
