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.
Hi,
I hope that there might be a solution after all.
I have an area diagram with two lines, and I want to mark the highest and lowest points of each line.
Is there a solution for this?
For one line I proceeded as follows, first I wrote the following measurer:
Max/MIN Abs.gross turnover Afterbuy Max =.
VAR Gross Sales = [Abs. Gross Sales Afterbuy Max]
VAR OfficeGross = [Abs. Gross Sales OfficeChairs]
VAR MaxABS =
MAXX ( ALL ( stock ), [Abs. gross sales Afterbuy Max] )
VAR MINABS =
MINX ( ALL ( stock ), [Abs. gross sales Afterbuy Max] )
VAR RESULT =
SWITCH (
TRUE ( ),
Gross sales = MaxABS, "Green",
Gross Sales = MINABS, "Red",
"Blue"
)
RETURN
RESULT
In the second step I converted the area chart into a line chart. And then applied it to the Columns for Meassuer. This was also possible without any problems.
However, as soon as there is a second Y-axis in the bar chart, it is not possible to set a conditional formatting for both.
Is there a way to achieve this?
Because as soon as I change the chart from the bar chart to the area chart, the formatting remains.
And locks like this, but of coure the red dote fore the dark blue line is wrong.
Thanks
Hi @Yonah ,
Based on my test, in the latest version, color of marks in the area chart doesn't support conditional formatting. May I know how you did it?
Best Regards,
Community Support Team _ kalyj
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |