March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi All,
I hope everybody's doing well. I am encountering a problem with my Waterfall Chart. I am trying to show the key factors that drive a numerical change from one period to another, breaking it down by activity. Illustration below:
As an extra level of detail, I would like to add a Pie Chart tooltip that breaks down these figures between our different operating regions. However, the tooltip only appears on the full columns, not on the breakdowns. Please find the illustration below:
Here is what happens when I hover over he blue column.
And here is what happens when I hove hover any breakdown column (green or red)
I have covered the financial information because I am not allowed to disclose them, but you can see that the Pie Chart tooltip is not displayed anymore.
I am now wondering: is it impossible to have the tooltip displayed when I hover over a breakdown column (because this function is not supported yet by Power BI), or am I doing something wrong.
Thank you very much and have an excellent day.
Best regards,
FM
Hi @v-luwang-msft ,
Thank you for your answer. I looked into the file you attached, but it seems that the solution that you are offering wokrs because there is no data in the 'Breakdown' field of the Waterfall Chart:
As soon as I add a data field in the "Breakdown" field, for example "Column 1", the tooltip stops appearing when I hover over the breakdown columns:
I have tried changing the option from 'show tooltip when Summarized' to ' show tooltip when used as category' and turning on the option "Keep all filters" in the Tooltip page, and even by changing the datafield in the 'Tooltip' field, it does not work.
Do you have any other idea? Maybe I am missing something.
Thank you very much in advance,
FM
Hi @GQJ ,
You could refer the following sample :(Returns a different tooltop depending on the subdivision column)
You can take a try to change the option from 'show tooltip when Summarized' to ' show tooltip when used as category' and turn on the option "Keep all filters"
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
125 | |
84 | |
67 | |
54 | |
43 |
User | Count |
---|---|
203 | |
106 | |
98 | |
65 | |
56 |