Hi All,
I have a data only for March and September month for years - 2023,2024 and 2025
My source data also has only these months in the date column
How do I add the date control which only has these values and not the whole calendar
Also when I select September 2025 My KPI should show September 2025 value, Previous Value as March 2025 and difference between them,
Now when I am selecting only September 2025 in the date slicer, the previous value and difference disappears
Please help!
Hi @Madhura28,
In regards to utilizing a datetime parameter; this are very limited options on what’s returned with the calendar drop downs; which includes filtering out months not included in your dataset. You would have to use a string parameter to limit the options based around your data.
In regards to the previous value/month instance; unfortunately Quick Sight’s logic does not work that way when dealing with dates or time. I would suggest trying to build a calculated field to use towards your trend group, maybe something that ranks your summed values based on your date fields, that way it understands that it should follow order from September over to March.
Hi @Madhura28,
Following up as it’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
Hi @Madhura28,
Since we have not heard back further, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
Thank you