Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply

Showing graph upon selecting slicer value

Can I show a graph upon selecting a slicer value?
6 REPLIES 6
spoony
Helper I
Helper I

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/15171...

 

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.

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?

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.