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

Conditional formatting does not work in my Table or Matrix

I have a calculated measure I use to determine what percent of productivity has been met by staff in my organization. I use a measure to determine this with the following formula:

 

 Target Hours Met % = sum(DirectService[Consumer Hours])/[Target Hours Total]

 

The calculation works fine, however when I add it into a Matrix or into a Table: Values and attempt to do Conditional formatting: Background color scales, it does not put the colors in. For whatever reason, the Data bars Conditional formatting does work, but not the Background color scales and not the Font color scales. Here's how they look. 1) The one cell table, 2) The Conditionalformatting options that are shown as available, 3) How I attempt to enter the background colors, which is accepted, but which does not actually show up on 1), 4) How I enter the Data bars conditional formatting, which does work as shown in 5).

New Bitmap Image.jpgNew Bitmap Image2.jpgNew Bitmap Image3.jpgNew Bitmap Image4.jpgNew Bitmap Image5.jpg 

 

 I've tried all of the different options in the Background color scales and nothing has worked, It does show up under the Remove conditional formatting: Background color scales. So I can add and remove the conditional format, it just doesn't show up in the cell.

1 ACCEPTED SOLUTION

Accepted Solutions
v-jiascu-msft Super Contributor
Super Contributor

Re: Conditional formatting does not work in my Table or Matrix

Hi @astevens,

 

Did you use a single value in the table visual? I would suggest using the custom visual "Card with states by OKViz" instead.

Conditional_formatting_does_not_work_in_my_Table_or_Matrix

 

Best Regards,

Dale

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

View solution in original post

8 REPLIES 8
Super User
Super User

Re: Conditional formatting does not work with my calculated measure

Hmm, that's interesing, I created a % measure and tried this and did not have any issue with any of the conditional 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!

edejes2
Advisor

Re: Conditional formatting does not work with my calculated measure

I have done the same no issues at all. What version of PBI desktop are you using?

 

Regards'

Erich Dejesus

astevens Frequent Visitor
Frequent Visitor

Re: Conditional formatting does not work with my calculated measure

Version: 2.53.4954.481 64-bit (December, 2017)

v-jiascu-msft Super Contributor
Super Contributor

Re: Conditional formatting does not work in my Table or Matrix

Hi @astevens,

 

Did you use a single value in the table visual? I would suggest using the custom visual "Card with states by OKViz" instead.

Conditional_formatting_does_not_work_in_my_Table_or_Matrix

 

Best Regards,

Dale

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

View solution in original post

jmeadows Frequent Visitor
Frequent Visitor

Re: Conditional formatting does not work with my calculated measure

I am having the same problem. I have created 3 measures (1 target and 2 current rates) and put these in to a table. When I try to add font or background conditional formatting to them, neither work. What did you do to overcome this? It's so frustrating!

astevens Frequent Visitor
Frequent Visitor

Re: Conditional formatting does not work in my Table or Matrix

This did work for me, using the OKViz custom visual. Still can't get the conditional formatting to work on the regular matrix/table visuals, but the custom OKViz was a decent work around. Thank you.

Highlighted
Gordon2 Member
Member

Re: Conditional formatting does not work in my Table or Matrix

Accually, conditional formatting (rules, color scale, field value) still not works (apr 2019 desktop version) in case you have several measures in rows in a matrix:

 

Capture5.PNG

There would be great to have this working

GregoryL Frequent Visitor
Frequent Visitor

Re: Conditional formatting does not work in my Table or Matrix

Accually, conditional formatting (rules, color scale, field value) still not works (Version: 2.68.5432.841 64-bit apr 2019  version).

 

This answer https://community.powerbi.com/t5/Desktop/Conditional-Formatting-not-working-for-one-row-table/td-p/6... did not work too.

 

image.png

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 267 members 2,698 guests
Please welcome our newest community members: