Forum Discussion

agd50's avatar
agd50
Helper V
2 years ago
Solved

Dynamic Subtitle (with Drilldown)

Is it possible to create a dynamic text that will update the time frame of data when you drilldown? Below is a chart to illustrate point:   So for example you drill down to 2020 and then Q...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi agd50 

    Can you please create a measure

     

    Dynamic Title = 
SELECTEDVALUE(Table[Year])&" "&SELECTEDVALUE(Table[Quarter])

     

    In visual title, use Fx and field value. Use the measure


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi agd50 

Can you please create a measure

 

Dynamic Title = 
SELECTEDVALUE(Table[Year])&" "&SELECTEDVALUE(Table[Quarter])

 

In visual title, use Fx and field value. Use the measure


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

agd50's avatar
agd50
Helper V
2 years ago

So simple but truly genius