Forum Discussion
Red Negatives without Conditional Formatting
- 1 year ago
Hi mdoan
Thank you for reaching out to the Microsoft Fabric Community Forum, Also thank you all danextian , Ritaf1983 and BhavinVyas3003 for your responding on this topic.
Unfortunately, there is no way to automatically color negative values red in a measure itself in Power BI without conditional formatting. DAX does not support returning formatted text with inline color instructions that visuals will interpret as color. If "drag-and-drop and automatically works is necessary," then the best practical approach is pre-build visuals or a report template where conditional formatting is already applied to your measures. Users then drag and drop pre-styled visuals, not raw measures.
If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.
Thank You!
Hi mdoan
There is no other oprion to format values , except of conditional formatting.
Unfortunately you cant use something like #,##0;[Red]-#,##0
on measure / column level like with excel.
You can suggest it as idea here :
https://community.fabric.microsoft.com/t5/forums/postpage/board-id/fbc_ideas
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly