Forum Discussion
Conditional Formatting - on live connection
Hi Experts I cannot get the resuts of the following dax to show the negative numbers as red........ vAOP$ =
VAR SummaryItem = SELECTEDVALUE( 'Templates'[Summary 1] )
Return
SWITCH(TRUE(...
Hello again,
You have to add this measure:
vAOP$_Color = SWITCH(TRUE(), [vAOP$] <0, "#ff0000", BLANK())
Then you need to do the following steps:
Hope that this works!
Kind Regards,
EDIT: I see that i picked Background color instead of Font color by conditional formatting.
This should be Font color.
Hi Anonymous,
What is your data source? I tested with live connection to SQL Server DB and SSAS Multidimensional model, conditional formatting option is available in both scenario.
Would you please post a screenshot? And update your Power BI desktop for a test.
Regards,
Yuliana Gu