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,

 

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. 

 

 

 

fjjpeeters1976's avatar
fjjpeeters1976
Helper III
1 year ago

Thanks a lot. It turned out that Power BI made automatic connections with my newly created Waterfall table messing things up. That solved the issue with the strange numbers. I had to change a setting within the graph not to have a total to get rid of the waterfall value column. I also tried the tooltip and it works. Thanks very much, very appreciated. You saved me a lot of time.

 

BR, Frank