Forum Discussion
Show category in Matrix table
Hello professionals, I have created a matrix table as below
but I need to show like this
so I need to to get a category lable for every 3 columns
please note: I am using calculated measures as columns
thank you
4 Replies
jaipal , Refer if these solutions can help
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795Hi jaipal
I think the result you want in your screenshot is to get hierachy level in Column Field in Matrix. However [Revenue], [Margin] and [%] are all measure/column names in Value field in Matrix. We couldn't create hierachy level in matrix by column headers. You need to transform your table like unpivot to get two column [Level1] and [Level2].
They looks like as below.
Level1 Level2
JOB to Date Revenue
JOB to Date Margin
JOB to Date %
...
Add them in Column in Matrix and get the hierachy level you want.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi jaipal
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,Rico Zhou
Hi Anonymous, thank you for follow up, I have created 3 tables in power query (MTD, YTD, ITD) and append them and I got this output
now you can see all the values are same. The desired outcome is to get cumulative YTD or cumulative ITD.
I can do this in DAX, but I don't know how to calculate the tables within the power query.
My concern is to get the output through power query.
Thank you
