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. 

     

     

     

mark_endicott's avatar
mark_endicott
Super User
1 year ago

fjjpeeters1976 - I'm afraid this is not how tooltips work, you'll need to have a rethink round how you'd like this data presented. 

 

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!