Forum Discussion

fjjpeeters1976's avatar
fjjpeeters1976
Helper III
1 year ago
Solved

Simple Waterfall Tooltip issue

Hi all,   I created below Simple Waterfall, every box is a separate measure. It works well and I am happy with the result, however now I want to create a tooltip that gives further information abo...
Show and Tell
Tips and Tricks
  • grazitti_sapna's avatar
    grazitti_sapna
    1 year ago

    Hi fjjpeeters1976,

     

    Let's do below checks

    WaterfallItems - Make sure this table is not related to any other table in the model (leave it disconnected).

    Make sure [Energy], [FixedCOGS], etc., are independent measures, not columns.

    The “WaterfallValue” is a single measure returning the correct value based on selected row.

    Ensure WaterfallItems[Item] is the only field in the axis. If you accidentally added WaterfallValue as a field, not a measure, it might show an unwanted row.

     

    • Axis (Category): WaterfallItems[Item]

    • Values: WaterfallValue (the combined measure)

    • Tooltip field (optional): Add WaterfallItems[Item]
      If you accidentally added WaterfallValue as a column or dimension, Power BI may treat it as a separate row (like “WaterfallValue”), which causes the visual to break or show odd numbers.

      If everthing seems fine, try iterating the steps carefully which i mentioned earlier. 

     

     

     

grazitti_sapna's avatar
grazitti_sapna
Super User
1 year ago

Hi fjjpeeters1976,

 

You can achieve this by following below steps:-

First create a disconnected table, use below DAX 

 

WaterfallItems = DATATABLE(
"Item", STRING,
{
{"Energy"},
{"Fixed COGS"},
{"Labour"},
{"Packaging"},
{"Total"}
}
)

 

Now Combine the measures which you've created into one dax (See Blow)

 

WaterfallValue =
SWITCH(
SELECTEDVALUE(WaterfallItems[Item]),
"Energy", [Energy],
"Fixed COGS", [FixedCOGS],
"Labour", [Labour],
"Packaging", [Packaging],
"Total", [Total],
BLANK()
)

 

Now 

 

  • Add WaterfallItems[Item] to the Category axis of the waterfall chart

  • Use WaterfallValue as the value

  • Add WaterfallItems[Item] as a tooltip field (optional)

  • Enable your tooltip page and set its page to accept context from WaterfallItems[Item]

Now Create a tooltip report page

 

 

  • Create a tooltip report page

  • Page Information:

    • Set "Tooltip" to On

    • Set "Page size" to Tooltip

  • Add your desired visuals

  • Add a slicer or card or logic that filters on WaterfallItems[Item]

    • It will receive the filter automatically from hover

Follow above steps and you'll be able to achieve dynamic changing tooltip

 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

 

 

mark_endicott's avatar
mark_endicott
Super User
1 year ago

grazitti_sapna - This is nice, I tried to think of a way to do this with a calculation group, but couldnt make it work. 

 

Very tidy solution!