Forum Discussion

UncleLewis's avatar
UncleLewis
Icon for Responsive Resident rankResponsive Resident
1 year ago
Solved

X 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 sl...
Need Help
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
1 year ago

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's avatar
    UncleLewis
    Icon for Responsive Resident rankResponsive Resident
    1 year ago

    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