Stacked Bar chart with true/false for multiple fields managing a lot of rows

[Wasabiii]

Hello everyone ! 

I know that there is several subjects about stacked bar with true/false, but every solution i saw used the unpivot column.

I have a table with +-10 columns true/false. From these columns I need to create a bar chart that shows each of these columns in two colors representing the true/false ratio.

I can't unpivot because i manage >300 000 rows soo it can't be convertible in columns.

I don't know if its possible ^^' Below some links that finaly didn't match with my idea : 

https://community.fabric.microsoft.com/t5/Desktop/Create-table-containing-count-of-True-false-of-mul...

https://community.fabric.microsoft.com/t5/Desktop/True-False-Column/m-p/591435

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-True-False-values-in-multiple-...

https://community.fabric.microsoft.com/t5/Desktop/Bar-chart-with-true-false-ratio/td-p/1061981

https://communities.gainsight.com/customer-success-cs-15/chart-showing-yes-no-or-true-false-count-fo...

[lbendlin]

I can't unpivot because i manage >300 000 rows soo it can't be convertible in columns.

That's not what unpivoting is about, quite the opposite.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Wasabiii]

Hello Ibendlin,

Here is a sample data : 

CODE	isStrong	isUseless	isSameToAnother	reasonDeletion
2090	0	1	0	Useless
21800	0	1	0	Useless
25563	0	1	0	Useless
36194	0	1	0	Useless
43116	0	1	0	Useless
69529	0	0	0	Not Strong
73564	0	0	0	Not Strong
82177	1	1	0	Useless
84812	1	1	0	Useless
84813	1	0	0	None
84814	1	0	1	Same to another
84815	1	0	0	None
84816	1	0	0	None
84817	1	1	0	Useless
84818	1	1	0	Useless
84819	1	1	0	Useless
84820	1	1	0	Useless
84821	1	1	0	Useless
84822	1	0	0	None
84823	1	0	0	None
84824	1	0	0	None
84825	1	0	0	None
84814	1	0	1	Same to another

In Power query i want to have this result at the end : 

CAT	True	False
isStrong	16	7
isUseless	12	11
isSameToAnother	2	21

So i tried to do a group on the table by using the reason deletion : 

Table.Group(#"Changed column type 2", {"reasonDeletion"}, {{"True", each List.Sum(List.Combine({[#"isUseless"], [#"isStrong"], [#"isSameToAnother"]}))}})

And im blocked here because my group by function doesn't work (obviously), but in DAX i can create a column and just write this after creating a new table with a column "Type" with two rows (True and False) :

col_isUseless = COUNTX(FILTER(ALL('Table'),'Table'[isUseless] = NewTableDAX[Type]), 'Table'[isUseless]) / COUNTROWS('Table')

So i can have this in DAX 

And i can do the stakedbar chart with true false correctly :

But my problem is that i use DAX and i want to have a table already correct in my dataflow soo it's why i ask for a solution in power query (and i think i'm in the good way but im blocked with that group by).

I hope that the details provided will help to better understand my problem.