cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Highlighted
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.

Highlighted
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...

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 378 members 3,903 guests
Please welcome our newest community members: