Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

     

PaulDBrown's avatar
PaulDBrown
Community Champion
1 year ago

Sure. Just wrap the measures you need to format differently in the FORMAT function with the necessary format type

RahulNadkarni's avatar
RahulNadkarni
Frequent Visitor
1 year ago

Thanks.

 

I need to change color of a column based on below condition for a percentage field

1) if between -2 nd 2 then green

2) for rest cases red

 

But it's changing all values to Green inspite of check condition

The mesure is of type percentage.

Please let me know in case any solution.

 

TEXT Code for MainReport =

VAR _CC =

    SWITCH (

        TRUE (),

        AND (

            SELECTEDVALUE ( 'MainReport'[INDEX] ) = 15 ,          

            [UTILIZATION%] > 2

        ), "red",

        AND (

            SELECTEDVALUE ( 'MainReport'[INDEX] ) = 15 ,         

            AND([UTILIZATION%] <= 2 ,

            [UTILIZATION%] >= -2)

        ), "green",

        AND (

            SELECTEDVALUE ( 'MainReport'[INDEX] ) = 15 ,          

            [UTILIZATION%] < -2

        ), "#ff0000"

    )

RETURN

    _CC