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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors