Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
You mean to use the legend as a slicer? Only works if it is a measure:
You can also setup a table of filters and add the measure to the graph and:
Measure = IF(COUNTROWS(FILTER(FilterTable, FilterTable[Column1] = "Measure1")) = 0, 0, Calculate....)
Thanks a lot Spoony, I will try this out and update you.
Hi @irfanreporting,
Based on my understanding, there is a following sample table, which have A, B, C columns. When you select A, it will display all the values(1,2) of A, you select B, it will display all the values(21,22) of A, right?
A B C
1 21 a
2 22 b
If it is, we are unable to do it in Power BI using slicer.
Best Regards,
Angelia
Yes Angela you are correct, I like to display like the way you have described. In my case, Values of Column A can be duplicate but with a unique dates.
A Version Date
----------------------------
1 V1 3/13/2017
2 V1 3/13/2017
3 V1 3/13/2017
1 V2 4/14/2017
3 V2 4/14/2017
Hi @irfanreporting,
As my original posted, we are unable to filter columns using slicer, which is used to filter the row in resource data. Thanks for understanding.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |