Forum Discussion

NJ81858's avatar
NJ81858
Icon for Helper IV rankHelper IV
3 years ago
Solved

Different Dates for different visuals

Hello,   I am putting together a metrics report and I am having some issues with dates. I have 5 visuals that I want to display the data between certain dates, but the 6th visual I only want to dis...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi NJ81858 ,

     

    Yes, it's possible. 

    You need a calendar table. You can create it using DAX.

    Calendar = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))

    Modify the two measures.

    Measure = IF(MAX('Table'[Date])>=MIN('Calendar'[Date])&&MAX('Table'[Date])<=MAX('Calendar'[Date]),1)
    Measure 2 = IF(MONTH(MAX('Table'[Date]))=MONTH(MAX('Calendar'[Date])),1)

    Based on the previous solution1, add a slicer of a calendar table to filter the date range.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

NJ81858's avatar
NJ81858
Icon for Helper IV rankHelper IV
3 years ago

Anonymous is there a way to make the first solution dynamic? So that is the user wants to see different months then the visual that shows the last month will change as well?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi NJ81858 ,

 

Yes, it's possible. 

You need a calendar table. You can create it using DAX.

Calendar = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))

Modify the two measures.

Measure = IF(MAX('Table'[Date])>=MIN('Calendar'[Date])&&MAX('Table'[Date])<=MAX('Calendar'[Date]),1)
Measure 2 = IF(MONTH(MAX('Table'[Date]))=MONTH(MAX('Calendar'[Date])),1)

Based on the previous solution1, add a slicer of a calendar table to filter the date range.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.