Ribbon chart total bar

[Anonymous]

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?

[v-yuezhe-msft]

@Anonymous,

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

[lndnbrg]

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?