The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
69 | |
68 | |
66 | |
55 | |
28 |
User | Count |
---|---|
112 | |
82 | |
66 | |
48 | |
43 |