Forum Discussion
Helper IIMissing conditional formatting on destop file based on Power BI service
Hello, I'm working with a desktop file that use POWER BI SERVICE as datasource and no CONDITIONAL FORMATTING is available.
Table fields
Field formatting
Hi marcodea,
It's right according to my test. These functions return numerical result. I am sure this feature will be improved. You can submit or vote an idea here: power-bi-ideas.
Best Regards!
Dale
7 Replies
- Greg_Deckler
Community Champion
A Power BI Service connection is a "live" connection and not everything works the same with live connections.
- marcodea
Greg_Deckler I'm really surprised about your reply and today I've a bad mood about Power BI.
Maybe was my fault, but I've ever came across a warning that reporting were affected by live connection.
In my opinion datasource and reporting should be distinct component of the system and not effetc each other in this way.
I hope there is a solution to this issue.
v-jiascu-msftMicrosoft Employee
Hi marcodea,
It seems only tables have conditional formatting. And it only works on the columns in the area "Values". According to my test, it works with a connection to the Service.
>>>With conditional formatting for tables, you can specify customized cell background colors based on cell values, including using gradient colors. To access conditional formatting, in the Fields well of the Visualizations pane in Power BI Desktop, select the down-arrow beside the value in the Values well that you want to format (or right-click the field). You can only manage conditional formatting for fields in the Values area of the Fields well.
Reference: powerbi-desktop-conditional-table-formatting
Best Regards!
Dale
