Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am using a basic Area chart, and I would like to display the negative area in red. It seems like it should be easy, but I cannot find a way to do it. Please see below:
Thank you for your time.
- William
Solved! Go to Solution.
Hi @wfarrell19 ,
We cannot achieve that using area chart directly. We can create a column chart to work around.
Here i create two measures.
Measure = SUM(Table1[log])
Measure 2 = IF([Measure]>0,"#a00d34","#3b9921")
Regards,
Frank
Hi @wfarrell19 ,
We cannot achieve that using area chart directly. We can create a column chart to work around.
Here i create two measures.
Measure = SUM(Table1[log])
Measure 2 = IF([Measure]>0,"#a00d34","#3b9921")
Regards,
Frank
Hi @wfarrell19 ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Well, the only way that I can think of is if you have a table with those positive and negative values or create a summary table with the aggregation that yields you those positive or negative values. Then you could create a calculated column that uses that to return "Positive" or "Negative" and then use that calculated column in your Legend. But, even then it won't look right.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |