Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
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.
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
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?
What do you mean by Title of the Sheet?