How to group data columns in matrix based on binary value

Hi avacadoDaily ,

For your first query- When I add the data to the condition data into the column section in power bi visualization, it splits the data but also adds a total section which i do not need.

Solution: In SubTotals section, turn off the Per row level and Per column level option.

The setting should be like:

For your second query of the sorting order, please refer any of the below as per your suitability:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

or

https://www.excelnaccess.com/custom-sorting-in-power-bi/

Please provide a Kudos to this answer if you found it interesting.

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