Forum Discussion

Millar's avatar
Millar
Frequent Visitor
2 years ago
Solved

Powerbi

how to hide table chart when nothing selected in stacked bar chart
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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:

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

     

    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 :

    and to use conditional formatting by value to put it :

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

    pbix is attached

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

Millar's avatar
Millar
Frequent Visitor
2 years ago

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 🙌🙌🙌

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Happy to help 🙂