Showing graph upon selecting slicer value

Question

Can I show a graph upon selecting a slicer value?

spoony · Answer

You mean to use the legend as a slicer? Only works if it is a measure:

https://community.powerbi.com/t5/Desktop/Using-slicer-to-choose-which-dimension-to-display/m-p/151711#M65618

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....)

irfanreporting · Answer

Thanks a lot Spoony, I will try this out and update you.

irfanreporting · Answer

Dear 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-msft · Answer

Hi&nbsp;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,&nbsp;it will display all the values(21,22) of A, &nbsp;right?&nbsp;A &nbsp;B &nbsp;C1 21 &nbsp;a2 22 &nbsp;bIf it is, we are unable to do it in Power BI using slicer.Best Regards,Angelia

irfanreporting · Answer

&nbsp;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.&nbsp;A&nbsp;&nbsp; Version&nbsp;&nbsp;&nbsp;&nbsp; Date----------------------------1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; V1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3/13/20172&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; V1&nbsp;&nbsp;&nbsp;&nbsp; 3/13/20173&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; V1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3/13/20171&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; V2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/14/20173&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; V2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/14/2017

Forum Discussion

Showing graph upon selecting slicer value

6 Replies

Related content

Selected slicer

Slicer default selection

Single select slicer

List slicer - Show only selected items

Between date slicer - calender selection