Forum Discussion
Power BI - Matrix : Column Header Grouping for multiple measures
Hi All, I have to build a matrix report as shown in the image below. The challenge is that I'm not sure how to custom group multiple measures in the column header. For example, there are three me...
Hi， Anonymous ；
You should create a table like below:
Then create a measure.
Measure = SWITCH(MAX('Table2'[Measurename]),"FTE COUNT",CALCULATE([Measure 1]),"TEMP COUNT",[Measure 2],"BUDGET TMPS",[Measure 3],"FTE",[Measure 4],"FORE",[Measure 5])The final show：
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
One way is to create a table with the measure names. See if this helps:
Thanks for forwarding the artcile. Very good insight. However, in my case, I need to group measures under two sections in the columns header and also be able to conditionally format values in each column/measure independently.