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.

lbendlin's avatar
lbendlin
Super User
4 years ago

Keep in mind that a slicer can only be populated by values from a column, not from a measure.

 

So what you would need to do is to have ALL of your formatting options pre-computed in that "Service Date" column, and then have another column that indicates which of the "Processing Interval" options the value corresponds to.  This also mandates single value selection on your "Processing Interval" slicer, but you already have that.