Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic Title

Hi All,   I'm trying to create a dynamic title for my card like below but facing issues. At the moment I've manually used the title but want it to be dynamic.     Any help in creating the ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks for the help.

     

    I actually created few measures and got the desired result.

     

    CurrentFY = CALCULATE( SELECTEDVALUE( D_DATE[FISCAL_YEAR] ),
                        FILTER( ALL( D_DATE ), D_DATE[Date] = TODAY() ) )
     
    Last quarter = ROUNDUP(MONTH(TODAY())/3, 0)-1
     
    Result :

     

     

JorgePinho's avatar
JorgePinho
Solution Sage
3 years ago

I thought you wanted to make it dynamic according to a slicer. If you used a slicer it would display the selected value on the slicer.

 

If you want to do it according to the system date you have to do a Lookup of the fiscal year using MONTH(TODAY()) and YEAR(TODAY())

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for the help.

 

I actually created few measures and got the desired result.

 

CurrentFY = CALCULATE( SELECTEDVALUE( D_DATE[FISCAL_YEAR] ),
                    FILTER( ALL( D_DATE ), D_DATE[Date] = TODAY() ) )
 
Last quarter = ROUNDUP(MONTH(TODAY())/3, 0)-1
 
Result :