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

Power BI is turning 10! Letโ€™s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Alice08
Helper III
Helper III

I want to hide chart based on slicer selection

I want to hide chart based on slicer selection, i have a clusterd column chart which i want to hide and display a white box which will display test as "No Data Available" when the country has been selected as "Canada" from Country slicer. Also it should allow user to interact with the chart when "Canada" is not selected.

1 ACCEPTED SOLUTION

Hi @Alice08 
Can you please check the link and let me know if it working as expected
https://app.powerbi.com/view?r=eyJrIjoiOTYzMTMyZmUtNzA2MS00YTRjLWJhNDQtMDBkNzk4N2EzOWU3IiwidCI6ImMwZ...

 

I will share the pbix file and steps




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

6 REPLIES 6
PijushRoy
Super User
Super User

Hi @Alice08 

I have added one blank Button, turn off border, background, Header icon
Use Measure2 in function of the buttom text
minimise the size of the shape so column chart can be intereactive 

PijushRoy_0-1742295135418.png

 


Find the PBIX file




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Hi @Alice08 

Is the ticket is resolved, please accept the solution and close the ticket.
If not, please let me know




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





PijushRoy
Super User
Super User

Hi @Alice08 
Please find the solution, please find the two measures

PijushRoy_0-1742239999349.png

PijushRoy_1-1742240179641.png

 

PijushRoy_1-1742240004559.png

PijushRoy_0-1742240121619.png

 

 

 

 

 

 

 



Find the attached PBIX

 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





@PijushRoy Hey i have tried the attached solution but it shows x and y axis titles

 

Alice08_0-1742280590259.png

Also i want output something like this -

 

Alice08_1-1742280678033.png

 

Hi @Alice08 
Can you please check the link and let me know if it working as expected
https://app.powerbi.com/view?r=eyJrIjoiOTYzMTMyZmUtNzA2MS00YTRjLWJhNDQtMDBkNzk4N2EzOWU3IiwidCI6ImMwZ...

 

I will share the pbix file and steps




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Yes this is exactly i want to develop.

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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