Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I can't see this asked/answered anywhere else so forgive me if my search missed an answer and point me in the right direction.
I've seen asolution to get a calculated value to include 0's where there are nulls in the data (simply add 0 to the calculation). However, from what I can see this does not work on the new ribbon chart visual. Instead of showing a trend that drops to 0 then rises again to the new count where it again exceeds 0, the ribbon chart just looks like a bar chart. Anyone know how to force it to reflect a drop to 0 or is this a 'bug' in the chart design. Surely I can't be the only one who wants to see the full trend instead of a broken flow?
Solved! Go to Solution.
I understand what you mean. But I haven't found any similar ribbon chart in visual market. I would suggest you submit the idea here to help power bi improve.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solved this problem by adding an insignificant value for the periods where the measure value is 0
In my case it looks like this:
I have made a test but couldn't reproduce your issue. The ribbon is continuous on my side as below. Please update power bi desktop to the latest version, if this issue persists, could you please share a sample file by sharing a onedrive link?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You have actually reproduced it. You have values that go to 0 (orange bar in 2019, orange and blue in2020), but as you don't have values in 2020 they just stop. If you had a value in 2020 for the orange bar I suspect you'd see exactly what I do.
What I'm saying is that if there is a value that has a 0 month, I'd expect the ribbon to narrow done to zero, then expand again to the new value.
I can't share ther actual data as its sensitive (hence I took the data labels off my screenshot). I can use a dummy dataset but that's going to look exactly like my screenshot and yours. I thnk its the way the visual is designed and what it probably should have is a flag to choose to show 0 values or not.
Actually, in revisiting this with dummy data I see the problem and can maybe illustrate it. Probably need a new/similar visual. Instead of the ribbon chart holding the order of a stack like a stacked area chart would it crosses the ribbons (insert Ghostbusters joke here). So it can;t really show 0 as a zero height ribbon. In the attached I set up a sample file with one set of values in the orders column and a second set with +1 to the value. Imagine on the second that the ribbon going down to 1 was actually 0 height and you might get what I originally meant; can we display 0 as a 'disappearing ribbon' instead of a gap. Like I say, I'm presumably looking for a different visual to the ribbon chart.
With image this time!
I understand what you mean. But I haven't found any similar ribbon chart in visual market. I would suggest you submit the idea here to help power bi improve.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is a link to the idea which needs votes:
https://ideas.powerbi.com/ideas/idea/?ideaid=355699f6-cb28-459c-975e-4bbd3450c8b6
Will do. I'd suggest it should be an option on the existing visual - toggle to display line for 0 or gap.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
127 | |
109 | |
93 | |
70 | |
67 |