Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

sundeep579

Matrix Conditional formatting not working in Power BI Embedded

Submitted by on ‎03-04-2021 01:17 AM

I have a Power BI report which is published into Power BI Service and is embedded into a web application using Power BI embedded. I added a Matrix visual in my report and to highlight few values, I have used conditional formatting to set the background color and the font color based on two set of rules. The conditional formatting is working fine in Power BI Desktop but when the PBIX file is published onto Power BI service, the background color specific conditional formatting is not working whereas the font color specific conditional formatting is working fine without any issues. I tried icons conditional formatting as well and even that is not working. I am using DirectQuery to connect to an Azure SQL database from Power BI report. This looks like a bug. Can you please help with this issue of if there is a workaround to this issue?

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-lili6-msft
Community Support
Community Support
‎03-04-2021 10:04 PM

hi

I use DirectQuery to connect to SQL database create a simple Power BI report, and use two set of rules to conditional formatting, then I publish it to power bi service, it works well.

5.JPG

I do not have  Azure SQL database, if you could use import have a try, and also make sure your power bi desktop is latest version.

 

 

Regards,

Lin

Idea Statuses