Forum Discussion
Red Negatives without Conditional Formatting
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
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!