Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |