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.

     

RahulNadkarni's avatar
RahulNadkarni
Frequent Visitor
1 year ago

Great solution. Perfectly work for case my client want the measures to be grouped under some criteria. Only issue is that some columns are numeric in Millian and some are in %.

It there any way we can format these individual mesures.

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