Filtering with 100% Stacked Bar Chart

Hi Anonymous ,

It's a bit difficult if you are using 100% stacked bars chart. Because it is always guaranteed that the final result of each bar is 100% (which would lose a lot of information).

We can make slight changes to the stacked bar chart so that it becomes a 100% stacked bar chart, and with cross-filtering, we can successfully achieve our goal.

The PBIX file is attached for reference:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data