highlighting weekends in a Line Chart combined with Bars

[miketsilis]

Dear all,

I would like to creat a line chart and highlighting the weekends with Bars (as shown in the pic below). Additionally I would like to show only the data for the MAX, MIN (this is already answered from previous post I did) but also the most Recent value (as for today is yesterday's data).
I post also a picture for showing what I mean more clear.

Thank you very much in advance. 

[v-nuoc-msft]

Hi @miketsilis 

Please refer to the content of this blog:

Use a Python script to annotate special points on ... - Microsoft Fabric Community

This should help you.

Regards,

Nono Chen

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

[miketsilis]

Hello @v-nuoc-msft is there any other way without using Python? I would like to do something which will be easily readable for other stakeholders. I am trying to do it using Dax but I am getting some errors.
MostRecentValue =
CALCULATE(
MAX('XTable'[Sales EU]),
FILTER(
'XTable',
'XTable'[Day_] = MAX('XTable'[Day_])
)
)
for that I am receiving an error "Column Sales EU" in table XTable cannot be found or may not be used in this expression. Do you know why it could be? Or do you have another alternative with DAX but not Python?

[rajendraongole1 · Accepted solution]

Hi @miketsilis - Please find the resolved solution for the similar scenerio

Solved: Highlight Weekends on Line Chart - Microsoft Fabric Community

you can also try with markers with different color. 

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[miketsilis]

Hello @rajendraongole1 thanks a lot. I was able to to highlight the Weekends