Forum Discussion
DataVizGuy
Advocate I
2 years agoDynamic 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
- ChiragGarg2512
Solution Sage
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.