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

Conditional Formatting

Hi All

 

As far as I'm aware, conditional formatting finally appeared in the May update of PBI Desktop. I now have the June update and I can't see it anywhere ! I've got some data with some averages that I'd like to apply conditional formatting to, but when I select the down arrow beside the measure I want to format (or right click the field), there is no Conditional Formatting option.

 

Am I missing something here ?

 

Paul

 

 

8 REPLIES 8
Microsoft
Microsoft

Hi @Paulx99,

Could you please share sample data of your scenario and describe more details about which fields you drag into the table visual? I am not able to reproduce your issue, when I create a table visual in the latest version of Power BI Desktop(2.36.4434.381), conditional formatting options appears as shown in the following screenshot.
Capture1.PNG

In addition, please make sure that you create a table visual rather than matrix visual, there are no conditional formatting option and “Do not Summarize” option in matrix visual. There is an example for your reference.

111.png



Thanks,
Lydia Zhang

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

Hi Lydia

 

Thanks for your reply. Unfortunately, I cannot share a sample of the data, due to confidentiality reasons. However, I believe you may have solved why conditional formatting is not working for me - my average figures are on a matrix, not a table. When I replicated a simple table example (such as you have shown below), the conditional formatting option appears. However, when I click on the averages in my matrix, the conditional formatting option does not appear. I was not aware that conditional formatting (and do not summarize) are not available options for a matrix visual. Now I know that, my question is why is that ?

 

I need to be ablel to apply conditional formatting to a matrix visual - a table visual is not suitable for the data I'm working with.

 

Do you know of any reason why MS would provide the conditional formatting option on a table, but not on a matrix ? Should this be suggested to MS as an enhancement ?

 

Regards

 

 

Paul

Hi @Paulx99,

I am not aware that if there are any plans about adding conditional formatting option to Matrix. However, about this feature, you can vote it and add comments in the following ideas.

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

Thanks,
Lydia Zhang

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

Hi Lydia

 

Thanks for the links - have just voted for it. If MS currently does not have any plans to add conditional formatting to a matrix, they should. To me, it makes no sense to be able to do conditional formatting on a table and not be able to do conditional formatting on a matrix. I use matrix's way more often than tables and ahve a real need to be able to apply conditional formatting to them. I will take this issue up directly with MS.

 

Regards

 

 

Paul

Community Champion
Community Champion

@Paulx99 It depends on which visual you're using but if you're using table visual then provided you've column of data type Whole Numbe or Decimal (basically number) then when you click on that dropdown you will get conditional formatting option. So make sure column you're trying to apply conditional formatting is of data type Whole Number or Decimal.

 

In addition for other visual type you can go to Paintbrush icon and under Data Colors apply conditional coloring.

 

Capture.PNG

 

ankitpatira

 

Thanks for your reply. I am using a table visual and both average columns on it are of decimal type.  I am still not getting the conditional formatting option. Any further suggestions ?

 

Paul

Hi @Paulx99,

 

when adding a simple table with column you can't find the conditional formatting sub menu as you described

check if you column has a "Do not summarize" option

try to set the sum option and the you'll see the conditional formatting sub menu.

 

Hi BIXL

 

Thanks for your reply. 

 

Unfortunately, I'm getting nowhere here ! All I'm doing is adding a simple table with a couple of numeric fields, where I am then clicking on the Values dropdown and ticking the 'Average' option. Neither column has a "Do not Summarize option". Setting the option to Sum does not bring up the conditional formatting menu - even if it did, is not going to achieve what I want - I need the average. Doing conditional formatting in Excel is simple - why is it so hard in PBI Desktop ?

 

As far as I'm concerned, if I have valid numeric fields and I click on any valid option in the Values dropdown, I should be able to see and use the Conditinal Formatting sub menu.

 

Paul

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors