Showing results for 
Search instead for 
Did you mean: 
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.



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.



Is there a way to remove the totals bar?

lndnbrg 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:


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


Does this help you?

Moderator v-yuezhe-msft

Re: Ribbon chart total bar


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.



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.