Display a range of dates

[Chapin4u]

Hi,

Need a tip if to do the following if it is possible.

I have date slicer and in card visual I need to display the selected range of dates in the slicer.

Thanks in advance for any help received to my requirement.

[Sean · Accepted solution]

@Chapin4u

Create a Measure using either one of the Measures below they should give you some ideas how to tailor to your setup!

The second Measure allows you to use a custom Year-Mo column which is not formatted as Date.

You can modify these many other ways 

In fact you can also use in conjunction with the FORMAT function!

Look at the Picture below to see the results...

Which way you decide to go will depend on how you aggregate your data.

Do you need to see the specific Dates or is Months only okay

Hope this helps!

Report FIRST/LASTDATE = FIRSTDATE('Calendar'[Date]) &" - "& LASTDATE('Calendar'[Date])

Report FIRSTNON/LASTNON 2 = 
IF (
    FIRSTNONBLANK ( 'Calendar'[Year-Mo], 1 ) = LASTNONBLANK ( 'Calendar'[Year-Mo], 1 ),
    FIRSTNONBLANK ( 'Calendar'[Year-Mo], 1 ),
    FIRSTNONBLANK ( 'Calendar'[Year-Mo], 1 ) & " ~ " & LASTNONBLANK ( 'Calendar'[Year-Mo], 1 )
)

Report Period FORMAT = FORMAT(FIRSTDATE('Calendar'[Date]), "MMM yyyy") & " - " & FORMAT(LASTDATE('Calendar'[Date]), "MMM yyyy")

[Boni]

Hi Guys ,
is it possible to show the actual slicer settings  from an text slicer in an seperat Cart / Box . 
Example: I chose the campaign "Campaings nr145" on my extra filter page. 
Now i am searching for an Box where i can see the actuell settings of the campaign slicer with out showing the slicer bos again.  
Thanks for help 

[007Dawg]

@Sean 

Is it possible to only show the date once when the range is the same date?

I tried using an if statement with your solution above then FIRSTDATE(date) as the other option but I keep getting #,0.00 when only one date is selected.

[Chapin4u]

Many thanks for a great explanation and the examples.