Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Tooltips for Stacked Column Chart

Hi everyone!

 

I have a stacked column chart over the date period. And I'm wondering, is it possible to calculate legend that will show values not only for the hovering segment of the bar but also for other segments?

 

So, for example, I hover over the green segment of the last bar and I see values for all segments of this bar:

 

Hope it's possible🤞

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for your answer!

       

      But I don't actually understand how to exclude filtering of tooltip by legend (colors of the bar) and keep filtering by slicers on the page.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      May be is it possible to do not by using page tooltips but using calculations?

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    5 years ago

    Hi, username

    Yes, this is not hard to achieve. You can use the tooltip page or the tooltip field. I've made a simple example to show this result. I created a simple table containing sales, costs, and profits.

    Method1: Drag the fields that need to be displayed into the tooltip

    Method2: To create a tooltip report page

    Sample：

    Result:

    Please check the sample file I attached below.

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know If you have further questions

     

    For reference：

    https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips 
    https://www.wallstreetmojo.com/power-bi-tooltip/ 

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.