Forum Discussion

Matt_Joers's avatar
Matt_Joers
New Member
4 years ago
Solved

Dynamically Format Date based on Slicer Selection

Greetings Team, I'm trying to figure out a way to dynamically format the date options in a Slicer based on another Slicer. In my example, here is how the dates should be formatted in the slicer:   ...
General Comment
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Matt_Joers 


    Try to create a measure like this:

    Format = 
SWITCH(
    SELECTEDVALUE(Slicer[Processing Interval]),
    "Daily",FORMAT(MAX('Table'[Date]),"mmm dd yyyy"),
    "Prior Month",FORMAT(MAX('Table'[Date]),"mm yyyy"),
    "Year To Date",FORMAT(MAX('Table'[Date]),"mmm dd yyyy")
    )

     
    Result:

    If you only want to see the formatted date, you can change the column width of the service date column to 0.

     

    Please refer to the attachment below for details. Hope this helps.

     

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, Matt_Joers 


Try to create a measure like this:

Format = 
SWITCH(
    SELECTEDVALUE(Slicer[Processing Interval]),
    "Daily",FORMAT(MAX('Table'[Date]),"mmm dd yyyy"),
    "Prior Month",FORMAT(MAX('Table'[Date]),"mm yyyy"),
    "Year To Date",FORMAT(MAX('Table'[Date]),"mmm dd yyyy")
    )

 
Result:

If you only want to see the formatted date, you can change the column width of the service date column to 0.

 

Please refer to the attachment below for details. Hope this helps.

 

 

 

Best Regards,
Community Support Team _ Zeon Zheng


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