cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shill1000
Helper IV
Helper IV

Showing 0 on new ribbon chart

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?value in Oct and Jan are not showing the trend down to 0 and back up to 1value in Oct and Jan are not showing the trend down to 0 and back up to 1

 

 

1 ACCEPTED SOLUTION

@shill1000 ,

 

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.

View solution in original post

8 REPLIES 8
gampy
Advocate I
Advocate I

Solved this problem by adding an insignificant value for the periods where the measure value is 0
In my case it looks like this:

 

System class =
VAR _year_amount =
    CALCULATE(
        SUM(Project_Data[Value])
        , FILTER(Headers, Headers[Group] = "System class")
    )

VAR _total_amount =    
    CALCULATE(
        SUM(Project_Data[Value])
        , FILTER(Headers, Headers[Group] = "System class")
        , ALL(Years)
    )

RETURN
    IF(ISBLANK(_year_amount),
        IF(_total_amount >= 1, 0.001, BLANK())
        , _year_amount
    )111.png
v-yuta-msft
Community Support
Community Support

@shill1000 ,

 

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?

Capture.PNG 

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!Ribbons.JPG

@shill1000 ,

 

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.

Will do. I'd suggest it should be an option on the existing visual - toggle to display line for 0 or gap.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.