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.
Conditional Formatting Dialog
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))
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
341 | |
99 | |
62 | |
51 | |
47 |
User | Count |
---|---|
328 | |
120 | |
84 | |
66 | |
65 |