Forum Discussion
Column Chart - Shade Future Dates with Week end date on x-axis
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
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.
9 Replies
- parry2k
Super User
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.
parry2k Worked like a charm !! Awesome Solution 🙂
- v-luwang-msft
Community Support
Hi AwesomePowerBI ,
Could you pls share your pbix file ,Remember to remove confidential data.
Best Regards
Lucien
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
- 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.
Sai_AlkeshHelper II
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
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
- parry2k
Glad to hear, and don't forget to subscribe to my youtube channel. Good luck!
