Formatting text value within table

[Anonymous]

Hello dear super users

Could I please get some advice for formatting the text values in the table please . 

I have created a staff leave report and each letter repressent different leave type, how can i format the letters with different colors ? In the table I have the staff names and the date (only 1-31) as it has a slicer filter out each month. 

below is the value area where the letters needs to format with different colors. I have used CONCATENATEX to convert the numbers to the letter as a measure.

Many thanks

[KNP]

I think I understand what you're wanting to acheive. Check out this and see if you can relate it to what you're trying to do.

https://www.youtube.com/watch?v=SO4mk1H94OA&ab_channel=EnterpriseDNA 

[Anonymous]

just had a look and it does helps but my knowledge is very limited as I am very new to power bi. Thanks for the reply.

cheers

[KNP]

Can you share the measure you are using that you referred to?

I may be able to help more with a little more detail.

[KNP]

What you're looking to do is set the conditional formatting based on your criteria.

If you go into the formatting for the matrix and set the conditional formatting you should be able to get the highlighting you want.

Have a look at this PBIX file. Very basic version of what I believe you're trying to acheive.

https://drive.google.com/file/d/1-7ToZf0rcB4xzI094EFqF_kNt484uFSc/view?usp=sharing 

[Anonymous]

Thanks for the advice and just tried and it worked . My goal for the visual is to format different colors based on the letters . for example, if letter is A then format to Orange , if letter is B then format to Blue ?

Thanks

[KNP]

So a measure like this...

Colours = 
VAR v =
    SELECTEDVALUE ( 'Table'[Column1] )
RETURN
    SWITCH (
        TRUE (),
        v = "a", "rgba(255,100,10,1)",
        v = "b", "rgba(10,10,255,1)",
        v = "g", "rgba(10,255,10,1)",
        v = "r", "rgba(255,10,10,1)"
    )

Used in conditional formatting...

Can produce what you want.

PBIX attached for your reference.

Hope this helps.

[Anonymous]

Hi 

Many thanks for that . Have used above code in the measure but got this syntax error 

I was trying to change the colors for what I needed for this report , also there are 31 columns and how can i include all of them please .

Thanks

[KNP · Accepted solution]

Remove two of the closing brackets I think.

Assign the same formatting to each column unfortunately. So pick the column and choose the same measure field. A little tedious.

[Anonymous]

Thank you so much for your help mr. much appreciated.