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 Q2 - it will show it as 2020 Q2 or showing the min and max time period dynamically.

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

3 Replies

  • 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