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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Composed_MS
Helper I
Helper I

Visual change based on slicer selection

I need to change my visual based on slicer selection of customer 

 

First Visual->

Composed_MS_0-1678896475965.png

 

 

Second Visual->

Composed_MS_1-1678896476103.png

 

 

So I have put in my dax for first visual (where the manufacturer is "abc")->

IF(SELECTEDVALUE(Customers[Customer]) ="abc",[abc],BLANK())
 
So it will take the measure when the "abc" customer is selected else it will show BLANK.
 
Similarly I have done for other visual as well, and it is working fine.
DAX for second visual("qwe") ->
IF(SELECTEDVALUE(Customers[Customer]) ="qwe",[qwe],BLANK())

I have disabled the background of visuals as well, suppose if my customer is qwe then only second visual (donut) will come, first one (bar chart) will be blank and as there is no background so it will be totally transparent.
 
But the issue I am facing is, as the first visual (bar chart) is in bottom and second (donut chart) is up in z order, so if I want to slice my page (when "abc" customer is selected) based on the first visual bars then that won't be possible as we have donut chart above it (although it is blank).
 
Can anyone please tell me how to do that?
0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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