Forum Discussion
Akash_Varuna
Super User
1 year agoConditional Formating Color
Hi Team, I have been facing an issue with conditional formating for a column the table is actually a View from sql analytics endpoint in fabrics the thing is the formatting is working for normal t...
- 1 year ago
Hi Akash_Varuna
This occurs due to following reasons below:
- Conditional formatting isn’t blocked for Views, but issues often come from how columns are exposed.
- Check if the column in the View is coming as text instead of numeric/date formatting won’t apply correctly.
- If it’s a calculated field, try casting it explicitly in SQL.
- In Power Query, verify the data type and change it if needed.
- Once the data type is correct, conditional formatting should work the same as with normal tables.
- 1 year ago
No limitation with Views.
Conditional formatting usually fails because:
Column comes in as text instead of numeric/date.
Column has NULL/blanks.
Using raw column → create an explicit measure and format that.
In DirectQuery, metadata from View may cause issues → test in Import mode.
Shahid12523
Community Champion
1 year agoNo limitation with Views.
Conditional formatting usually fails because:
Column comes in as text instead of numeric/date.
Column has NULL/blanks.
Using raw column → create an explicit measure and format that.
In DirectQuery, metadata from View may cause issues → test in Import mode.