Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
130 | |
110 | |
93 | |
70 | |
67 |