Forum Discussion
re: Datamatrix Custom Formatting of Row Colors
- 5 years ago
Hi KrisCachia ,
For pie chart and column chart. you can change the color for all legends in Data colors:
For matrix, you can use conditional formatting : https://medium.com/@raghu.949/conditional-formatting-of-matrix-visual-in-power-bi-9d37dd70c52e
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
- 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
KrisCachia - I think you want to use the colours of your pie chart in your column charts and matrix.
You can chnage the data colors of column chart from the format tab under visualization tab.
And for matrix you can write formula for the coloring.
Appreciate your kudos!! Mark this post as solution if it helps.