Hey @AniGaikwad ,
Yes, you can create a dynamic chart title based on the currently visible level of a fiscal hierarchy (Fiscal Year, Fiscal Quarter, Fiscal Month) in a stacked column chart using DAX in Power BI. Since you’re working with a text-based hierarchy and have tried common functions like ISINSCOPE, HASONEVALUE, and ISFILTERED, here’s a refined solution tailored for your scenario.
Solution
1. Understand ISINSCOPE for Hierarchies
The ISINSCOPE() function works best for identifying the deepest level visible in a hierarchy. You need to check the levels from deepest (Fiscal Month) to highest (Fiscal Year) in reverse order because Power BI evaluates all visible levels.
2. Create the Dynamic Title Measure
Chart Title =
SWITCH(
TRUE(),
ISINSCOPE('Date'[Fiscal Month]), "# Customers by Fiscal Month",
ISINSCOPE('Date'[Fiscal Quarter]), "# Customers by Fiscal Quarter",
ISINSCOPE('Date'[Fiscal Year]), "# Customers by Fiscal Year",
"# Customers"
)
Replace 'Date' with the name of your date table and ensure [Fiscal Month], [Fiscal Quarter], and [Fiscal Year] are the exact column names used in your hierarchy.
3. Use the Title in the Chart
- Select the stacked column chart.
- Go to the Format pane → Title → Turn it On.
- In the fx button (conditional formatting), bind the title to the Chart Title measure.
Why This Works
- ISINSCOPE('Date'[Fiscal Month]) returns TRUE only when that level is active (i.e., visible as the granularity on the X-axis).
- The order of conditions matters: check Month → Quarter → Year, as multiple levels may be in scope simultaneously depending on drill behavior.
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam
