Solved: Re: Display my slicer selection date (relative dat...

PowerBITesting · ‎09-03-2020

Is it possible for me to display my slicer selection values in the labels or text field for title purpose.

Expected result - Sales amount for last 7 Months

read the values from the slicer

amitchandak · ‎09-03-2020

@PowerBITesting , Create a measure like

measure = "Sales amount for last " & dateiff(min(Date[Date]), Max(Date[Date]),month) & "Months"

refer dynamic title

https://www.youtube.com/watch?v=TYLKDPcvgK8
https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎09-03-2020

@PowerBITesting , Create a measure like

measure = "Sales amount for last " & dateiff(min(Date[Date]), Max(Date[Date]),month) & "Months"

refer dynamic title

https://www.youtube.com/watch?v=TYLKDPcvgK8
https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Greg_Deckler · ‎09-03-2020

@PowerBITesting - Should be something like:

Measure = MIN('Dates'[Date]) & "-" & MAX('Dates'[Date])

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...