Forum Discussion
Matrix visual and measures
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 !
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.
1 Reply
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.