Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |