Matrix-Format Values by Row

[Anonymous]

Hello-

I am trying to format each row values seperatly like the KPI Matrix allows but I need to not use the KPI Matrix; please help:

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

A measure can only have a data type. You may create a measure to make it display different text like below.

FormatMeasure = 
IF(
    ISINSCOPE('Table'[Name]),
    SWITCH(
        SELECTEDVALUE('Table'[Name]),
        "A",SUM('Table'[Score])&"!",
        "B",SUM('Table'[Score])&"@",
        "C",SUM('Table'[Score])&"#",
        "D",SUM('Table'[Score])&"$",
        "E",SUM('Table'[Score])&"%",
        "F",SUM('Table'[Score])&"^",
        SUM('Table'[Score])
    ),
    IF(
        ISINSCOPE('Table'[Class]),
        SWITCH(
            SELECTEDVALUE('Table'[Class]),
            "c1",SUM('Table'[Score])&"c1",
            "c2",SUM('Table'[Score])&"c2",
            "c3",SUM('Table'[Score])&"c3",
            SUM('Table'[Score])
        ),
        IF(
            ISINSCOPE('Table'[Grade]),
            SWITCH(
                SELECTEDVALUE('Table'[Grade]),
                "g1",SUM('Table'[Score])&"g1",
                "g2",SUM('Table'[Score])&"g2",
                SUM('Table'[Score])
            ),
            SUM('Table'[Score])
        )
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[Greg_Deckler]

@Anonymous - Not sure what the KPI Matrix allows but generally you would create a Measure that returns different values in particular instances within the matrix and you base your conditional formatting on that measure. It is sort of kind of like the Complex Selector only probably a bit fancier. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

[Anonymous]

Thank you; however, I am not trying to apply conidtional formatting I understand that. I am trying to change the format of the value by row. One line might be a % the other a number, the next a text. The KPI Matrix Vis allows you to do this through a drop down menu for each row item as shown below; I can not figure out how to recreate this on my own: