Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.