Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All Genuises,
I want to create a dynamic chart title based on current drill-down level/filter and should reflect value from that certain column.
Example: I have a 5 level drill-down, A->B->C->D->E. Tried to use a measure but getting all filter values in chart title.
On drill-down to "C", I want "Sales for C" and not as "Sales for A->B->C"
if its for D, then "Sales for D"
Query: Measure to return current filter / drill-down value on entire page.
Thanks
Solved! Go to Solution.
I am using below code for Dynamic Chart Title
I am using below code for Dynamic Chart Title
Hi @Riteshheda,
You can refer this to achieve Dynamic Chart Title.
The sample works well.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Riteshheda,
Maybe Drill Pathways can meet your needs, please refer: Drill pathways
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for reply, but not looking for drill solution. I want Dynamic Chart Title based on selected drill level.
Example: I have a 5 level drill-down, A->B->C->D->E. Tried to use a measure but getting all filter values in chart title.
On drill-down to "C", I want Chart Title as "Sales for C" and not as "Sales for A & B & C"
On drill-down to "D", I want Chart Title as "Sales for D" and not as "Sales for A & B & C & D"
Try disabling the "Keep all filters" option
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |