Matrix group

[khalidjou]

Hi all, 

I am struggling to have a matrix like the example below in the image.

The context: from the original table, I unpivoted the columns, ease of getting, signage access, value of money, and Arrival.

Then I created another table where Arrival is a category for the above variable. but when I display them in a matrix I get the score for the category as the sum of other variables. What I want to do is to show the count of the Arrival value in the unpivoted columns like in the image.

I hope my message is clear. Thank you for the help

[Anonymous · Accepted solution]

Hi  @khalidjou ,

You can try creating a matrix visual in Power BI Desktop. You can refer to the tutorial:

Create a matrix visual in Power BI - Power BI | Microsoft Learn

For the hierarchy, please use the drill down, refer to

Using drill-down actions with the matrix visual

For the arrows up and down, refer to

Add conditional icons

Best Regards,

Stephen Tao

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

[Uzi2019]

Hi @khalidjou 
Please show you input and the expected output.
what exactly your data looks like??