Column Chart - Shade Future Dates with Week end date on x-axis

[AwesomePowerBI]

Hi Experts,

I have a stacked column chart with continuous x-axis for date. (Future dates are shaded to differentiate between past and futute)

For better readability, I want to change the x-axis labels from Year to Week End Date and hence I am using Categorical x-axis. But while doing so, I lose the ability to create a dynamic x-axis vertical refrence line and the shaded area as shown below:

Can anyone guide me on how to get the below final output as below  :
1. Week end dates on x-axis
2. Future dates shaded

Sample .pbix file : - https://drive.google.com/file/d/1DRZZCAml9qixp0T5UVHim6F_LDyk6IzT/view?usp=sharing

@parry2k 

[parry2k]

Glad to hear, and don't forget to subscribe to my youtube channel. Good luck!

[parry2k]

@Sai_Alkesh I just checked the link and it is working, here it is again Enhance Report Visuals by Highlighting Data Points! (perytus.com) also there is a sample download link at the bottom of the page.

Do join my youtube channel at youtube.com/@PowerBIHowTo

[Sai_Alkesh]

Thank you so very much @parry2k .

Works like a charm 

[Sai_Alkesh]

@parry2k - hi, can you please share your PBIX file. I have a similar query, where i need to highlight future periods, where i have multiple values and not able to proceed. Your earlier links do not seem to have the file.

Thank you in advance.

[parry2k]

@AwesomePowerBI Glad to hear. I realized I don't have a video of this one on my YT channel. Going to do a video soon, please share the channels with others. Cheers!!

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[parry2k · Accepted solution]

@AwesomePowerBI did you check this blog post I have on shading/highlight the data area Enhance Report Visuals by Highlighting Data Points! (perytus.com)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[AwesomePowerBI]

@parry2k Worked like a charm !! Awesome Solution 🙂

[v-luwang-msft]

Hi @AwesomePowerBI ,

Could you pls share your pbix file ,Remember to remove confidential data.

Best Regards

Lucien

[AwesomePowerBI]

Hi @v-luwang-msft 
Thanks for your reply. Attached is the .pbix file.

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

Thanks