Setting visibility of graphs/tables based on selected value

[fjjpeeters1976]

Hi all,
I have created below waterfall chart and I am now working on a tooltip to show more information for each item. As each of below items require a bit different explanation, some need a split into accounts, others need a split in entity etc it would be great if I could toggle the visibility of visuals based on selected fields. For example when I hover above the category energy people might want to see a split in gas, electricity etc, but when they hover over Group Recharges they might want to see entities. Is there a way that when they hover over energy they only see the graph with the split but not the others and the other way around? Would be best if it could be done without using bookmarks. Any creative ways are welcome.

[Anonymous]

Hi @fjjpeeters1976 ,
Thank you @Elena_Kalina  and @Nasif_Azam  for the helpful response!

I just wanted to kindly follow up to see if you had a chance to review the previous response provided by community members. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.

Thank you.

Regards,
Pallavi G.

[Elena_Kalina]

Hi @fjjpeeters1976 

Try to do the following

1. Create separate tooltip pages:

   • "EnergyTooltip" (with gas/electricity breakdown)

   • "RechargesTooltip" (with entity breakdown)

2. Configure visual interactions:

   • Select your waterfall chart

   • Go to Format → Edit interactions

   • For each category button:

     • Set "Energy" to show "EnergyTooltip"

     • Set "Group Recharges" to show "RechargesTooltip"

     • Set all others to "None"

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[Nasif_Azam · Accepted solution]

Hey @fjjpeeters1976 ,

You can achieve the desired effect without using bookmarks by implementing dynamic visibility through a combination of separate visuals, slicers, and DAX measures. Here's a step-by-step approach:

1. Create Separate Visuals for Different Splits: For each category, set up separate visuals to display the corresponding split information. For instance, one visual can show a split for "Energy" (Gas, Electricity, etc.), while another can display the breakdown for "Group Recharges" (entities, etc.).

2. Use a Selection Control or Slicer: You can add a slicer or dropdown to allow users to select a category (e.g., Energy, Group Recharges). This control will determine which visual to display. Sync Slicers can be helpful to apply the same slicer across multiple pages or visuals.

3. Dynamic Visibility via DAX Measures: Write DAX measures to determine the visibility of visuals based on the selected field. For example, you could create a measure like this:

   ShowEnergySplit = IF(SELECTEDVALUE(Category[CategoryName]) = "Energy", 1, 0)

   You can use this measure to conditionally format visuals, adjusting their visibility based on the user's selection.

4. Control Visual Visibility with Conditional Formatting: By applying conditional formatting to properties like Transparency, you can hide visuals when they are not needed. For instance, if "Energy" is selected, the visual for energy splits would be shown, while others would be hidden by setting their transparency to 100%.

5. Custom Tooltips for Detailed Information: Power BI allows you to create tooltips that can provide additional information. You can set up dynamic tooltips that change depending on the category being hovered over, ensuring that users get the most relevant data for each selection.

For Detailed Information:

Power BI Visual Interactions
Conditional Formatting in Power BI
DAX to Control Visual Visibility
Using Slicers and Filters

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam