cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
chaturaa Frequent Visitor
Frequent Visitor

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.  

bi6.JPG

 

I used the matrix in powerBi and got the view without the color.

 

bi4.JPG

 

Any ideas to get the colors on the matrix as same as excel? 

 

bi1.JPG

 

Regards,

C.

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
quentin_vigne Senior Member
Senior Member

Re: A colored module view in Matrix

Hi @chaturaa

 

Follow this steps to get your colored module like in excel : 

 

Click on the little arrow of your value field : 

 

table-formatting-1-remove.png

 

You have to add a rule color

 

table-formatting-1-color-by-rules-dialog.png

 

And then fill it with all your rules

 

 

table-formatting-1-color-by-rules-if-value.png

 

 

Have a good day

- Quentin

quentin_vigne Senior Member
Senior Member

Re: A colored module view in Matrix

@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

6 REPLIES 6
quentin_vigne Senior Member
Senior Member

Re: A colored module view in Matrix

Hi @chaturaa

 

Follow this steps to get your colored module like in excel : 

 

Click on the little arrow of your value field : 

 

table-formatting-1-remove.png

 

You have to add a rule color

 

table-formatting-1-color-by-rules-dialog.png

 

And then fill it with all your rules

 

 

table-formatting-1-color-by-rules-if-value.png

 

 

Have a good day

- Quentin

chaturaa Frequent Visitor
Frequent Visitor

Re: A colored module view in Matrix

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? 

bi7.JPG

 

Thank you,

Regards,

C.

quentin_vigne Senior Member
Senior Member

Re: A colored module view in Matrix

@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

Hardik Established Member
Established Member

Re: A colored module view in Matrix

chaturaa Frequent Visitor
Frequent Visitor

Re: A colored module view in Matrix

Hi @Hardik,

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

Regards,

C.

chaturaa Frequent Visitor
Frequent Visitor

Re: A colored module view in Matrix

Hi @quentin_vigne,

Your solution works fine Smiley Happy 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. 

 

BI8.JPG

 

Best Regards,

C...