Forum Discussion
A colored module view in Matrix
Hi all,
im trying to build a dashboad on PowerBI desctop to get a visualization of a production module view. I did it in a excell using a macro. Just a simple color coding based on the given code(Style). Basically a color was given according to the list given on a seperate sheet. Same codes are coloring with the same color to indicate the continuation.
I used the matrix in powerBi and got the view without the color.
Any ideas to get the colors on the matrix as same as excel?
Regards,
C.
Hi chaturaa
Follow this steps to get your colored module like in excel :
Click on the little arrow of your value field :
You have to add a rule color
And then fill it with all your rules
Have a good day
- Quentin
Are you using the latest version of PowerBI ?
May update added this functionality : https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting
- Quentin
6 Replies
Hi chaturaa
Follow this steps to get your colored module like in excel :
Click on the little arrow of your value field :
You have to add a rule color
And then fill it with all your rules
Have a good day
- Quentin
Hi quentin_vigne,
Im afraid that the value field is a text in this scenario. So i dont have any conditional formatting option. Appciate if you also can advice me an another Visualization idea to do this?
Thank you,
Regards,
C.
Are you using the latest version of PowerBI ?
May update added this functionality : https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting
- Quentin
This article will solve your problem.Please go through this one
