Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Chapin4u
Microsoft Employee
Microsoft Employee

Display a range of dates

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.

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@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 Smiley Happy

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! Smiley Happy

 

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")

Report Filtered Dates Demo.gif

 

View solution in original post

4 REPLIES 4
Sean
Community Champion
Community Champion

@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 Smiley Happy

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! Smiley Happy

 

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")

Report Filtered Dates Demo.gif

 

Boni
Frequent Visitor

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 




@Sean 

Is it possible to only show the date once when the range is the same date?007Dawg_0-1629999752732.png

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
Microsoft Employee
Microsoft Employee

Many thanks for a great explanation and the examples.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.