cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
v-yuezhe-msft
Microsoft
Microsoft

@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

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.
lndnbrg
Resolver III
Resolver III

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?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!