Matrix visual and measures

[Anonymous]

Hi everyone ! 

I am having some issues while trying to create a matrix visual. Since it's not possible to create a hierarchy with measures I can't disply the matrix the way I want.
I don't want the measures related to another team to be shown in the column. I've divided my visual into 2 matrix to explain what I'm looking for. Here's a screenshot to make things clrearer.  
Does anyone have a solution or a work around for this type of issues ? 

Thanks in advance ! 

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

Create a table that contains what columns you need under each level you specify, like the following:

Then create a measue to switch measure which you have created to calcualte.

Example measures = 
switch(SELECTEDVALUE('Table in matrix visual'[level2]),
"column_name_1",CALCULATE([column1],'Table'[level1] = SELECTEDVALUE('Table in matrix visual'[level1])),
"column_name_2",CALCULATE([column2],'Table'[level1] = SELECTEDVALUE('Table in matrix visual'[level1])),
"column_name_3",CALCULATE([column3],'Table'[level1] = SELECTEDVALUE('Table in matrix visual'[level1])),
"column_name_4",CALCULATE([column4],'Table'[level1] = SELECTEDVALUE('Table in matrix visual'[level1])),
"column_name_5",CALCULATE([column5],'Table'[level1] = SELECTEDVALUE('Table in matrix visual'[level1])))

The result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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