I only want to visualize dates on X-axis in a dynamic time frame

[HaiNguyen2k4]

I have a table with two columns: order_date and customers. I want to create a line chart [Revenue by dates]. I want to visualize dates on the X-axis between the first date (today) and the last date selected by the slicer.  I use SELECTEDVALUE to get the selected date from the slicer but it doesn't work. 

Please help me find a solution to this. Thanks, guys a lot

[uzuntasgokberk · Accepted solution]

Hello @HaiNguyen2k4 ,

Could this be resolved by setting your slicer option to 'Between,' which would display it as a date picker slicer? I believe this approach might be suitable for your case.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |