Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
@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.
User | Count |
---|---|
97 | |
77 | |
77 | |
47 | |
26 |