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
Millar
Frequent Visitor

Powerbi

how to hide table chart when nothing selected in stacked bar chart

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Millar 
You can create a flag measure that checks if some value of the graph is selected. 
For example, if my graph rankin some measure by-products that will look like this:

Ritaf1983_0-1704428921206.png

Ritaf1983_1-1704428966512.png

Now you can use this test measure to filter a table : (note that you have to have different columns at the graph and table)

Ritaf1983_2-1704429041703.png

Ritaf1983_3-1704429069334.png

 

To make the user's life easier, you can use conditional formatting on the title that will guide him to make a selection from the graph if the table is blank.
You can create a measure for the title of the table like :

Ritaf1983_4-1704429268005.png

and to use conditional formatting by value to put it :

Ritaf1983_5-1704429364919.png

and to make it red use conditional formatting of the title color

Ritaf1983_6-1704429499394.png

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
Millar
Frequent Visitor

Thanks but I want it for stacked bar chart x axis has month-year(like 12-2023) y axis has count of(sales id) if user clicks bar then in another chart it show sales id details (like row wise 1,2,3)

Please share a link to pbix with example + show the desired result 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Ritaf1983
Super User
Super User

Hi @Millar 
You can create a flag measure that checks if some value of the graph is selected. 
For example, if my graph rankin some measure by-products that will look like this:

Ritaf1983_0-1704428921206.png

Ritaf1983_1-1704428966512.png

Now you can use this test measure to filter a table : (note that you have to have different columns at the graph and table)

Ritaf1983_2-1704429041703.png

Ritaf1983_3-1704429069334.png

 

To make the user's life easier, you can use conditional formatting on the title that will guide him to make a selection from the graph if the table is blank.
You can create a measure for the title of the table like :

Ritaf1983_4-1704429268005.png

and to use conditional formatting by value to put it :

Ritaf1983_5-1704429364919.png

and to make it red use conditional formatting of the title color

Ritaf1983_6-1704429499394.png

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Here my solution based on your inputs

 

scenario :- when nothing is selected in the staked bar chart - another visual should be completely hidden. when the staked bar is selected it should show another visual detail

 

PBI-Dynamic way of hide another table chart visual and its value ( without using bookmark and buttons

===================================================

 

Select the visual which you want to hide then go to filters-> drag measure ->Hide Table = int(ISFILTERED('DMADP OPEM_ADP_DATE_D'[Year-Month]))-> Show item when the values is 1

 

Select visual where you want to hide Title & border

 

Change Title color as" White"

 

Chnage Border Color as " White"

 

Then go general -> Title -> Text(FX) and select measure Hide Title = if([Hide Table]=0," ","Open in JIRA")

Thanks a lot for your support Ritaf1983.. Much appreciated 🙌🙌🙌

Happy to help 🙂

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors