Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Can you assign colours to values using a theme?

Hi All,

 

I have an issue developing a report where i have an extensive brand list in my report (1000 brands), in my visualisations i was wondering if there's a way to programatically asign a brand value a colour. Selecting the colour through the data colour formatting would take to long and could be reset when altering the chart.

 

In other tools i have used you've been able to asign a colour to a value in the back end so whenever that brand appeared the data point would be coloured that way.

 

Does this exist in PowerBI or is there another clever way to do this?

 

Thanks for your help

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , in your Brand table, merge or add a column with Hexcode or color names

     

    Now create a measure

    max(Brand [Brand])

     

    Use this in conditional formatting with the field value option

     

    This will work when some column is there in visual form brand/product table

     

    Refer this, I have given color in the measure itself, but I have only few values

     

    How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4