X Axis 15 Months

[UncleLewis]

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

[Ashish_Mathur]

Hi,

I have solved a similar question in the attached PBI file.

Hope this helps.

[UncleLewis · Accepted solution]

Thanks @v-yajiewan-msft ,

Got it sorted based on this video from Amit Chandak

https://www.youtube.com/watch?v=44fGGmg9fHI

Use 2nd Date Table - disconnected

Use 2nd Date Table for User Slicer Selection

Thanks,

-w

[v-yajiewan-msft]

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

[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]))

[UncleLewis]

Thanks @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