Forum Discussion
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...
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?