cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Conditional formatting on Rows

Hi ,

 

I want below color formating on rows .I want either font or background color according to status value.I m not able to achieve this any help please.

 

image.png

 

 

 

 

 

 

 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: Conditional formatting on Rows

@TomMartens Thanks for replying

 

I have used below approach.

 

I have created Color Table with Color Id and Color Name Columns

image.pngimage.pngimage.png

View solution in original post

9 REPLIES 9
Highlighted
Helper IV
Helper IV

Re: Conditional formatting on Rows

Currently there is no cappibility for custom formatting text, but you could create a custom column which inserts a number for each color. Then you can create a custom formatting rule using your custom column.

Highlighted
Super User III
Super User III

Re: Conditional formatting on Rows

Hey,

 

this is my table

image.png

 

using conditional formatting on column this ...

image.png

 

... like so ...

image.png

 

... creates this output (i already did the same for the column that) ...

image.png

 

Important: you have to use a Power BI Desktop version that supports Conditional Formatting by "Field value", this feature has been introduced in Power BI Desktop with the August 2018 release, as I'm using the October release - it's there. You may have to consider to upgrade your current Power BI Desktop version if your version does not this option.

This blog post by Chris Webb lists the supported color names: https://blog.crossjoin.co.uk/2018/08/10/colour-names-supported-in-power-bi-conditional-formatting/

 

Please be aware, that there is a little glitch (but does not have any effect on functionality) within the dialog of the Conditional Formatting, but this will be fixed soon. Whenever you make the setting for the Conditional Formatting the dialog will look similar to this:

image.png

 

Hopefully this is what you are looking for!

 

Regards,

Tom

 

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Helper III
Helper III

Re: Conditional formatting on Rows

@TomMartens Thanks for replying

 

I have used below approach.

 

I have created Color Table with Color Id and Color Name Columns

image.pngimage.pngimage.png

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Conditional formatting on Rows

Hi @atul9063

 

Glad to hear you've solved it, please accept your solution, that way, other community members will easily find the solution when they get same issue.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate I
Advocate I

Re: Conditional formatting on Rows

this solution doesn't work 

Highlighted
New Member

Re: Conditional formatting on Rows

This solution doesn't work.... Or there's some step missing....

Highlighted
Helper V
Helper V

Re: Conditional formatting on Rows

I belive we have to do this for each column in table. 

 

Is there anyway to do the Conditional Background Color for whole row and not individual column? 

Highlighted
Helper V
Helper V

Re: Conditional formatting on Rows

Highlighted
Regular Visitor

Re: Conditional formatting on Rows

I found that cross filter direction needs to be 'both' in the relationship if using the original Color ID in visuals.

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors