cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShawnPrice Regular Visitor
Regular Visitor

Change colors based on certain factors

Is is possible to change color on text based on certain factors? As in the example below.

 

Item            Q1       Q2      Q3     Q4

Coat             22       13       54      53

Shovel          30        5         15     25

 

I would like to change the 54 & 30 to bold or a different color to show the person viewing the report which Quarter was the best without really having to look through the row.

6 REPLIES 6
BhaveshPatel Super Contributor
Super Contributor

Re: Change colors based on certain factors

 

@ShawnPrice

 

You can use conditonal formatting feature but it is only supported in the table visual and with measures only. FYI- Microsoft has considered to make Conditional Formatting more rich and supported in other visuals in future releases.

For this, You need to create 2 measures.

 

Total Coats:=SUM(Table1[Coats]), 

Similarly for Total Shovels.

 

Create a Table Visual and Drag ITEM Field, Total Coats Measure and Total Shovels Measure as shown in the Screenshot.

conditional.PNG

As shown in the Screenshot, Select the drop down arrow of the Total Coats measure, and select conditional formatting.

It will pop up with a new dialog box as shown in the below screenshot.\

conditonal2.PNGConditional Formatting Dialog Boxconditonal3.PNGFinal Output

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Super User IV
Super User IV

Re: Change colors based on certain factors

I believe that both Table and Matrix visualizations have cell conditional formatting now, definitely tables. 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

BhaveshPatel Super Contributor
Super Contributor

Re: Change colors based on certain factors

Hi @Greg_Deckler

 

Hmm..  I just did the test and It is only supported in Table and not Matrix. 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
ShawnPrice Regular Visitor
Regular Visitor

Re: Change colors based on certain factors

I'm wanting to do this in a Matrix, sorry for not mentioning it before.

Highlighted
Steve_Wheeler Established Member
Established Member

Re: Change colors based on certain factors

Conditional formatting can (just now) be applied to cell backgrounds in tables only - you can't use conditional formatting on cell text in tables, or on a matrix.

 

Shawn,

Your example looks like a matrix with Items and Quarters as columns, not measures.  You can use conditional formatting  of text in an R visual using geom_text() - see https://community.powerbi.com/t5/R-Script-Showcase/Heatmaps/td-p/68573 for a related example.

Super User IV
Super User IV

Re: Change colors based on certain factors

Ah yes, I remembering seeing it as started here:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15310341-conditional-formatting-i...

 

Maybe end of this month?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors