cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Paulx99 Member
Member

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
ankitpatira Super Contributor
Super Contributor

Re: Conditional Formatting

@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

 

Paulx99 Member
Member

Re: Conditional Formatting

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

BIXL Member
Member

Re: Conditional Formatting

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.

 

Paulx99 Member
Member

Re: Conditional Formatting

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

Moderator v-yuezhe-msft
Moderator

Re: Conditional Formatting

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.
Paulx99 Member
Member

Re: Conditional Formatting

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

Moderator v-yuezhe-msft
Moderator

Re: Conditional Formatting

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.
Paulx99 Member
Member

Re: Conditional Formatting

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

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

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: 256 members 3,160 guests
Please welcome our newest community members: