Can't find conditional formatting in Power BI? Check our fix

Reading time icon 3 min. read


Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

fix Conditional Formatting Issues in Power BI

Power BI allows the users to access conditional formatting for tables. It allows you to specify customized cell colors based on cell values and other values or fields. However, some users have reported that that can’t find conditional formatting in Power BI services and Desktop client in the PowerBI community forums.

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.

Follow the troubleshooting tips in this article to fix Power BI Conditional formatting issues.

Why there’s no conditional formatting option in Power BI?

1. Only Tables Support Conditional Formatting

  1. Conditional formatting is only supported by tables with columns of the whole numbers or decimals only.
  2. Making sure that you are using numbers with the tables, click the Drop-down menu and you should see Conditional Formatting option.
    can't find conditional formatting Power bi
  3. If you don’t see the conditional formatting option, make sure that the data type for the selected column is in decimals.
  4. Also, make sure that you create a table visual or matrix visual, as other visual chart does not support conditional formatting.

If you want to apply conditional coloring for Visual Type do the following.

  1. Open the Visual document that you want to apply conditional coloring.
  2. Click the Paintbrush icon.
    can't find conditional formatting Power bi
  3. Under Data Colors, you can apply conditional coloring.

Looking for the best diagram and flowchart software for Windows? Here are the best options.


2. Update Power BI Desktop Client

can't find conditional formatting Power bi

  1. Go to Microsoft Power BI Download Center.
  2. Scroll down to Microsft Power BI DEsktop and select the Language.
  3. Click the Download button.
  4. Run the installer and update the Power BI desktop client.
  5. Launch Power BI desktop after the update and check for any improvements.
  6. Microsoft adds new functionality to the Power BI client every now and then.

If the issue persists, try to reinstall the Power BI Desktop client.

can't find conditional formatting Power bi

  1. Press Windows Key + R to open Run.
  2. Type control and press OK to open the Control panel.
  3. Click on Programs > Programs and Features.
  4. Select and uninstall Power BI Desktop.
  5. Now follow the earlier steps to download and install the latest version of Power BI Desktop client.
  6. Restart the computer and check for any improvements.

Note: To install Power BI Desktop you need to have administrator access.

If you still can’t find conditional formatting in Power BI, consider contacting support.

RELATED STORIES YOU MAY LIKE:

User forum

0 messages