Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts,
I want to show the list of measures in a slicer like revenue and quantity etc and single chart should the respective values based on the selection.
How it is possible? How to capture the value selected in a slicer?
isfiltered function is returning always false for me.
Help me out
thanks,
Divya
Solved! Go to Solution.
Hi @DivyaP
In this scenario, you should fisrt create a table to list all the measures (e.g. measure1, measure2, measure3...) that will be used in the chart. Add this column into a slicer so that you can select which measure to use.
In the single chart, yo only need to create one measure, its formula can be like below:
Measure = IF(LASTNONBLANK('Table1 2'[Column1],"")="measure1",1, IF(LASTNONBLANK('Table1 2'[Column1],"")="measure2",2,0))
Best regards,
Yuliana Gu
Hi @DivyaP
In this scenario, you should fisrt create a table to list all the measures (e.g. measure1, measure2, measure3...) that will be used in the chart. Add this column into a slicer so that you can select which measure to use.
In the single chart, yo only need to create one measure, its formula can be like below:
Measure = IF(LASTNONBLANK('Table1 2'[Column1],"")="measure1",1, IF(LASTNONBLANK('Table1 2'[Column1],"")="measure2",2,0))
Best regards,
Yuliana Gu
Hi Yuliana,
Thank you so much for the solution. I tested your formula on some sample and it seems to be working.
Regards,
Divya
I'm not understanding your question, can you provide some sample data or more explanation?
If you have data like:
category,value
A,10
A,10
B,25
C,30
You can create measures based on value. If you put category in a slicer and then your category and measures in a visual then selecting something in your slicer should change your other visual.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |