Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Power BI community,
I am having a little trouble with my waterfall chart. As seen below, the negative values are not below the 0 line on the y axis, this is making the chart look rather strange.
Does anyone know how to format this?
Does anyone also know how to get rid of the "Other" category? I have already expanded my breakdowns to the maximum of 10, which should be sufficient for my chart.
Thanks!
Darren
As seen below, the negative values are not below the 0 line on the y axis, this is making the chart look rather strange.
By design, the negative values of the breakdown doesn't show below 0 line, it shows the what's contributing to the changes month to month (negative and positive, in waterfall chart)
To make the chart look more obviously, you could change the color of negative differenly from positive colors.
Does anyone also know how to get rid of the "Other" category? I have already expanded my breakdowns to the maximum of 10, which should be sufficient for my chart.
As tested with my data with 7 distinct category (this column added in the breakdown field), when i set breakdown to 7, it show all categories without "other" item, when i set to 6, it show an "other" item.
Please show me some example of your data added into this visual so i can anlyze better for you.
Best Regards
Maggie