Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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(), SummaryItem = "EMEA", FORMAT([EMEA Revenue vAOP$ 2],"#,##0.0%;(#,##0.0%)"), SummaryItem = "Americas", FORMAT([Americas Revenue vAOP$ 2],"#,##0.0%;(#,##0.0%)"), SummaryItem = "APAC", FORMAT([APAC Revenue vAOP$ 2],"#,##0.0%;(#,##0.0%)"), SummaryItem = "IDIS", FORMAT([ID & IS Revenue vAOP$ 2],"#,##0.0%;(#,##0.0%)"), SummaryItem = "Total", FORMAT([$NSvPY4% (NOE @ AOP Rate)],"#,##0.0%;(#,##0.0%)"), ISBLANK(SummaryItem),FORMAT(0.0,"$#,##0.0;($#,##0.0)"))
Solved! Go to Solution.
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.
I am also experiencing a similar problem. I am connecting with the PowerBI dataset via Live connection and cant use conditional formatting on the text of any object via dax measure.
@Anonymous Did you find a asolution for this problem?
@Anonymous I think I was missing a simple step. After creating a measure, change the datatype of measure to text. Cause by default it was Number and that's why couldn't be used.
I hope that will solve your problem too.
@Anonymous That did the trick. Thank you!
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
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 Jeltex
my connection into Power Bi is a Live Connection that option os disabled.....
Is it possible to use conditional formatting on any value or is it disabled at your whole report?
Never used live connections before so I don't really know.
If it is disabled I don't think that it is possible right now.
You might want to create a new idea at this link.
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |