The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Conditional formatting is being very buggy. I have a table with a text field that uses conditional formatting based on a rule and a numerical field.
The first issue came when I published to PowerBI.com. The conditional formatting was gone and all fields appeared white. I was able to fix this by editing the report in Power BI.com, opening the conditional formatting rule and closing it and that seemed to kick the formatting in.
Now, I have added two new rows to the database table that is the source for my report. I am using direct query. When I refresh the data, the new rows do not have conditional formatting while the other rows still do.
If I pull the column the formatting is based on into my table, suddenly all rows have the proper formatting. But if I remove that column, the two new rows appear white again. This is making me crazy!
@rbrock a few years late but...did you ever find a solution to this issue? I'm facing the exact same problem:
- Conditional formatting is based on an ID field. Such an ID exists for every row in the dataset.
- All IDs appear in the table visual until I start adding measures.
- Once I add measures, only rows with a value for at least one measure remain.
- When I click on 'Shows items with no data' in the table, all IDs are back to appearing. However, certain IDs are not formatted despite meeting the criteria...which once again is based on the ID field and not measures.
- When I add 'Measure = 1' to the table, all of the IDs appear and are conditionally formatted.
- Similarly, if I do not add 'Measure = 1' to the table, but rather switch the ID to 'First' instead of 'Don't Summarize', all IDs appear and are conditionally formatted.
I would like to understand why this is happening
@rbrock ,
The latest version of Power BI Desktop seems to work for me. You may also try Color formatting by field value.
Update: I have some dollar value fields in the table that are blank and set to summarize using the sum function. When I added values into those fields, the formatting worked. This is strange though since the formatting is in no way based on those fields. When I set those dollar value fields to all be do not summarize the conditional formatting worked.
This is fine for my purposes but it does not seem like it should work this way. Am I doing something wrong?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |