Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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.
Solved! Go to Solution.
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
Proud to be a Super User! | |
Thanks @agd50
Proud to be a Super User! | |
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
Proud to be a Super User! | |
So simple but truly genius
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 21 | |
| 21 | |
| 20 | |
| 13 |
| User | Count |
|---|---|
| 59 | |
| 53 | |
| 41 | |
| 31 | |
| 26 |