A colored module view in Matrix

[chaturaa]

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.

[quentin_vigne · Accepted solution]

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

[Hardik]

https://community.powerbi.com/t5/Community-Blog/Conditional-Formatting-in-Power-BI-Tables/ba-p/42799...

This article will solve your problem.Please go through this one

[chaturaa]

Hi @Hardik,

Im using this for the Matrix. Table view is not suitable for my scenario. Anyway Thanks. 

Regards,

C.

[quentin_vigne · Accepted solution]

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

[chaturaa]

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.

[quentin_vigne · Accepted solution]

@chaturaa

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/#conditionalForma...

- Quentin

[chaturaa]

Hi @quentin_vigne,

Your solution works fine 🙂 Thank you so much!

Just need a little help. I just need if the first style is equal to exactly the rule that i mentioned, it should show the given color. But in this case the color based on drop down is only giving the option of count of styles and summarization give count and count distinct. Also cannot give a text rule for condition formatting right?

Thank you so much for the support given. 

Best Regards,

C...