Forum Discussion
How to keep total values in bar chart
Hello,
I would like to know if there is a way to keep my total values visible in a bar chart when I apply filters. In this photo, my bar charts have no filters applied.
No filters applied
In the photo below, I applied a filter. All inapplicable responses are removed from the display.
Filter applied
I would like to be able to select a filter and still see a comparison to the total responses, as it appears when I click on one of the bars in the bar chart. Does anyone know how this might be possible?
What I want it to look like when a filter is applied
Hi rmaxfield ,
When a slicer is selected, related visualizations are displayed with the data selected by the slicer, which cannot be achieved as you say to keep other raw data, you can refer to the following link:
Showing totals and slicer selections in bar chart - Microsoft Power BI Community
Solved: How to get slicer to highlight bar chart elements,... - Microsoft Power BI Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi rmaxfield ,
When a slicer is selected, related visualizations are displayed with the data selected by the slicer, which cannot be achieved as you say to keep other raw data, you can refer to the following link:
Showing totals and slicer selections in bar chart - Microsoft Power BI Community
Solved: How to get slicer to highlight bar chart elements,... - Microsoft Power BI Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.