How to have simple text display the dates that are in the date range slicer?

[rpredmore]

Hello,

I have a Power BI report with a date range slicer. The date range slicer is in a menu that is hidden behind a hamburger icon

(user has to click the hamburger icon to open the menu to see and edit the date range slicer). I want the user to be able to see what dates are selected in the date range slicer without needing to click open the slicer menu. (I want them to be able to see the dates only, if they want to edit the dates they will need to open the menu and make the edit in the date range slicer).

Does anyone know how I can accomplish this?

[v-lionel-msft]

Hi @rpredmore ,

Try this.

Measure = 
VAR x = MIN('Table'[Date] )
VAR y = MAX('Table'[Date])
RETURN
x & "--" & y

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@rpredmore , You can remove the bookrmarks or Have a slicer that is not controlled by slicer

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[camargos88 · Accepted solution]

@rpredmore ,

You can create a measure, formatting the result and displaying it on a card.

The measure should get the min and max values selected, like:

Measure:

VAR _minDate = CALCULATE(MIN(TABLE[DATE]), ALLSELECTED(TABLE))

VAR _maxDate = CALCULATE(MAX(TABLE[DATE]), ALLSELECTED(TABLE))

RETURN

   "Date: " & FORMAT(_minDate, "YYYY-MM-DD") & " - " & FORMAT(_maxDate, "YYYY-MM-DD")

Check the attached file.