Dynamic chart title to be filtered by Filter pane and slicer

[beekee]

Hi everyone,

I have a measure to display dynamic title. This measure is restricted to show the range based on the condition in Filters pane. When I select Fiscal Period = 2021, the measure supposed to show "Total units from Sep'2021 to Dec'2021" but I'm not sure how I can achieve that. Does anyone know how to improve on the measure?

Measure = 

VAR startMth = CALCULATE([(Slct) Year_Month_Short],FILTER(Dim_Date,Dim_Date[CurMonthOffset]=0))

VAR endMth = CALCULATE([(Slct) Year_Month_Short],FILTER(Dim_Date,Dim_Date[CurMonthOffset]=8))

return

"Total units from " & startMth & " to " & endMth

When Fiscal Period = All

When Fiscal Year = 2021

Regards,

BK

[amitchandak · Accepted solution]

@beekee , if your fiscal year start from Sep and end at Aug.

You can use datesytd with date table 

examples

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"8/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"8/31"))

refer if needed

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA