Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
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")
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")
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
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.
Many thanks for a great explanation and the examples.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
120 | |
74 | |
72 | |
58 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |