Cross filtering chart for Boolean values

[Buerckj]

I am working on a vsiualization of the count of various boolean columns. I have created a column for each case where 1 or 0 indicates true or false for the value in question. When I filter one of the columns for 1 or 0, it removes the 1 section from all other column filters. How do I allow each filter to select 1 or 0 without affecting all of the other filters. I have tried removing cross filtering on a file level and individual level with no results. Thanks for your help with this!

[Ashish_Mathur]

Hi,

I do not know what your source data looks like.  Explore the "Unpivot Other Columns" option in Power Query.

[Anonymous · Accepted solution]

Hi, @Buerckj 

Maybe you can use Slicer. I create a sample table:

Then select the format on top page, and select the Edit interation.

Set each slicer to filter only the tables related to it, and the other slicers and tables to None

Here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.