Forum Discussion
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.
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
