Forum Discussion
Responsive ResidentX Axis 15 Months
Hi all,
Using PBID Aug 2024.
How can I get 15 months on x axis even when user only selects 12 months from slicer
The max date should be the max date the user selectes from the slicer.
My slicer has 3 years 21, 22, 23 with respective quarters
User may select any combination they want - though most common will be current / most recent year.
I selected 2021 from the slicer so the MaxDate to return on 15 month charts is 12/31/2021.
But I am getting 12/31/2023.
Is there any way to get to get the max date the user selected so I can calculate the 15 month span?
Thanks,
w
Thanks Anonymous ,
Got it sorted based on this video from Amit ChandakUse 2nd Date Table - disconnectedUse 2nd Date Table for User Slicer Selection
Thanks,-w
5 Replies
- Ashish_Mathur
Super User
Hi,
I have solved a similar question in the attached PBI file.
Hope this helps.
vicky_The way to get the Max date of a slicer would be something like:
Max Selected Date = CALCULATE(MAX(Table[Date]), ALLSELECTED(Table[Date]))
UncleLewisThanks vicky_ ,
Yes, that works if the visual interaction is on from the Slicer to the Column Chart
But I turned the interaction off because I always want to display 15 months on the Colum Chart even though the user might select 12 months (Year) from the hierarchy slicer ( Year |Quarter ).
Thanks,
-w
Hi UncleLewis , hello vicky_, thank you for your prompt reply!
For better understanding and testing, please provide a pbix example that completely covers your issue or question.
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to How to provide sample data in the Power BI Forum - Microsoft Fabric Community
- UncleLewis
Thanks Anonymous ,
Got it sorted based on this video from Amit ChandakUse 2nd Date Table - disconnectedUse 2nd Date Table for User Slicer Selection
Thanks,-w
