cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nielsvdc Frequent Visitor
Frequent Visitor

Ribbon chart total bar

I've created a ribbon chart to display itemcategory sales per month. And we have data available for 3 years. It look really good unfiltered.

all.png

 

But when I filter this for 1 year, the total bar for the 3 years is still visible and I want to be able to remove thisbar. I don't need this comparison.

2017.png

 

Is there a way to remove the totals bar?

2 REPLIES 2
Highlighted
lndnbrg Member
Member

Re: Ribbon chart total bar

Are you filtering the chart by clicking another visual? Or with a slicer?

 

If you cross-filter with another visual it keeps the totals as a default. But there is a way to change this behaviour:

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

 

You need to change the visual interactions to "Filter" instead of just highlighting.

 

Does this help you?

Moderator v-yuezhe-msft
Moderator

Re: Ribbon chart total bar

@nielsvdc,

I cannot reproduce the issue when using a slicer to filter the Ribbon Chart, so how do you filter the visual?

 

In general, though the value are summed, the value of each bar should be dynamic and depends on current time range, please double check your settings of filter, you could share your .pbix file via Private Message so that we could look into it.

 


Regards,
Lydia

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