Dynamicaly how to display the selected time period in the title

[RashmitaR]

Hi I want to change the title of a sheet dynamically according to the time selected in the timeline slicer(from date & to date).For time being I am using time line slicer .But, if I dont want to use it and display the filtered dates i.e from date & to date as the title of my sheet dynamically, is there a way to achieve it.

[v-haibl-msft]

@RashmitaR

Which title do you want it to change dynamically? The first marked part of Timeline will change dynamically based on your selection in this visual. But the title (second marked part) of stacked column chart will be static.

You can take a look at this idea and vote it if it describes the same requirement as you.

Best Regards,

Herbert

[RashmitaR]

I actually want to place a card visual on th top of my report sheet that will display the selected time period in the page level or report level filter. I want to do so because my client wants to have a clear idea about which durations data is he having a look at.

[v-haibl-msft]

@RashmitaR

We can create a calculate measure with formula like below and put it in the card visual. It will change dynamically according to the date selection in the Slicer, but cannot be impacted by the selected time period in the page level or report level filter.

Card_Measure = 
MIN ( Table1[Date] ) & " to "
& MAX ( Table1[Date] )

Best Regards,

Herbert

[Anonymous]

Great advice on the card measure however, can it be manipulated anymore to disregard the hours, minutes, and seconds that are imported with the date? 

[BhaveshPatel]

What do you mean by Title of the Sheet?