Forum Discussion
Showing graph upon selecting slicer value
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.
- irfanreporting9 years agoHelper IDear spoony,
Is it possible to display just corresponding column values from the table without using any inbuilt functions like min, max,sum,avg etc?- v-huizhn-msft9 years agoMicrosoft Employee
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- irfanreporting9 years agoHelper I
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