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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

This works when we want to just showcase the consolidation in dates, for example, here we have used MAX(date).
Is there any way to present all the dates and not just the MAX or MIN of date ?
I want to use date column on Y axis.
and as a slicer I have Annual, Monthly, Daily,
So if Annual is selected, all the dates should be YYYY
if monthly selected then, MM/YYYY and so on

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Abandon that idea and use a date column and zoom sliders.