Forum Discussion

KrisCachia's avatar
KrisCachia
Frequent Visitor
5 years ago
Solved

re: Datamatrix Custom Formatting of Row Colors

Hi all,   I am relatively new to powerbi and i am creating a report with various visualisation charts like pie chart, column chart and a datamatrix table. I want to use the same colours of each pro...
  • KrisCachia's avatar
    5 years ago

    thanks for the feedback guys, based on your help and some of my research i found a way how to set pie, column visuals and matrix products all with the same colors 

     

    I added a field column in my sharepoint list datasource called product color and entered colors for each product, and in powerbi matrix used conditional formatting on product values based on the product color field. Voila values in matrix colors automatically coloured. Then in each visual, pie and column, i manually added the hex code of each color which was entered in the product color column.  

     

    A good update for powerbi would be if they introduce a feature that would allow visualisation colors of field to be controlled via color name or hex code value coming from a column in datasource. That would give power bi better control to standardise colors beteween visualisations and data matrixes