Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am working on modifiying a report where we have a measure that finds out the change in sales of every product, displayed in percent. I need to format it accordingly:
Positive change - green
Negative change - red
No change (0) - white
I've tried writing a calculated column with an IF statement that finds out if the change/index is positive, negative or zero and returns the value 1 if positive, -1 if negative and else 0. Unfortunately there's a similar calculated column we're using, and I get the circular dependency error message.
We don't want any color gradient, but only a defined red, defined green and white. I can't figure this out.
Any idea of how I can get around the circular dependency or any other suggestion on how to solve this?
Kind Regards,
TM
I believe the right answer you are looking for was explained by this gentleman :
Center your formatting on 0 (Minimum).
If you have decimal places then your Max would be diferent.
You can currently do conditonal formatting on individual measures green for +ve(0.0001) red for -ve(-0.0001) and white for 0. But this has to be done for every measure.
FORMAT NEGATIVE NUMBERS RED, POSITIVE GREEN
I went looking for the answer to this question this morning. Did not find the exact answer, but close enough to figure it out. FRUSTRATING that I needed to create another column (per field) I wanted to format this way. SAMPLE:
W2 Index = IF('Product Sales'[W2 Projected Inventory] < 0,-1,1)
@TM,
Currently, conditional formating in not supported in Power BI since we can't add field value in conditional formatting. And it's not supported to set conditional formatting based on another column. A workaround is that add another column to assign static value and configure conditional formatting on that column. Please refer to the link below to see the details.
https://community.powerbi.com/t5/Desktop/Conditional-formatting-based-on-dynamic-values/m-p/177823#M...
Regards,
Charlie Liao
Hi @TM
could you give us some sample data for that.
I can't see why there should be a circular dependency when you just write a calculated column
ColorIndex = IF([VALUECOLUMN] < 0; -1; IF [VALUECOLUMN]=0;0;1))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |