Making High/Low markers green-red on the line chart

[sonya7]

Making High/Low balls green-red on the line chart. How can I make a graphical representation of any KPI to be selected on the line chart where total orders values ​​are displayed monthly, in a way that makes the highest value within the months green, the lowest value red and the remaining gray?

[Ritaf1983]

Hi @sonya7  To achieve the conditional formatting for line markers based on minimum/maximum value you can apply these steps (you didn't attach the dataset, so I used mine) :

1. Calculate min/max measures that ignore the date filter coming from the graph:

sum_for_min = CALCULATE(min(space_missions[Price]),ALLSELECTED('calendar'[Date]))

sum_for_Max =

CALCULATE(max(space_missions[Price]),ALLSELECTED('calendar'[Date]))

Then create a flag measure that checks if your measure is minimum/maximum/other

flag max_min_other = if([sum_price]=[sum_for_Max],1,if([sum_price]=[sum_for_min],2,0))

Then create a column chart + use the flag measure as a condition to format the columns' colors (we can't do it directly on a line chart )

Abd then just change the graph type to a line chart 

Note: My example is in blue/red and not green/red because the use of traffic light colors for emphasis is prohibited under the accessibility law. People with color blindness may not be able to see the difference...

PBIX is attached 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[sonya7]

hello, thank you. But when I look at the file you sent, I see different values ​​in the table. That's why it was wrong in my own dataset too. Why might this problem occur? Can you put it in a table?

I also want it to be affected by the date filter, but it looks like yours is not.

[Ritaf1983]

Hi @sonya7 
The graph is working with the slicer perfectly :

I didn't understand the first part of your question....please share your PBIX

[sonya7]

https://drive.google.com/file/d/14Wmxnz9qKwKCqfPTlYjnI15CS2gpBn2S/view?usp=sharing

[Ritaf1983]

Hi @sonya7 

This is a complex model, and regrettably, I lack the time to recreate it.

For instance, I didn't understand why you were using dates from different tables. To achieve the desired visualization, you typically need a fact table and its associated dimension date table properly connected.

[sonya7]

I added a date table.  Can you try it like this? I want the above chart to be a line chart and I want the max value to be green and the min value to be red. I wrote the same formulas as yours.

https://drive.google.com/file/d/1Vn8KcHdnDxxv70hCMcUU5BCHtNwzqYxV/view?usp=sharing

[Ritaf1983]

Hi @sonya7 
I see that the relationship with the dates table still doesn't work as it should ....