Forum Discussion

DataVizGuy's avatar
DataVizGuy
Icon for Advocate I rankAdvocate I
2 years ago

Dynamic Title Based on Date Hierarchy

I am trying to implement a dynamic title displaying Fiscal Year (calculated column within a date table), but only when the full Fiscal Year is displayed within the visual.

 

If the end user selects a specific quarter and/or month from the date hierarchy, I would want the title to show up as blank.

 

Any ideas on how to implement this? So far I have the following DAX:

 

FYLabel = 
VAR SelectedFY =
    IF(ISFILTERED('Date Table'[FY]),VALUES('Date Table'[FY]))
    RETURN
    SELECTEDFY

 

 

However the code above still shows the selected Fiscal Year, even when only certain quarters or months are selected underneath that Fiscal Year. 

1 Reply

  • DataVizGuy , this happens because quarters and months do filter the fiscal years. Keep only the fiscal year slicer and add blank in the if statement for when it's false.