Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Formatting text value within table

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...
Need Help
  • KNP's avatar
    KNP
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

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's avatar
KNP
Icon for Super User rankSuper User
5 years ago

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's avatar
    KNP
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        KNP
        Icon for Super User rankSuper User
        5 years ago

        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.