Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm using the parameter for the below chart, but not able to change the title for this. When I select the Profit by Parameter, then the title is showing Sales, not Profit.
Kindly let me know, how can the change the title for the same.
Regards,
Akhilesh Gupta
Solved! Go to Solution.
Hi Akhilesh,
Create seperate titles instead of Chart Title. Using below logic using DAX.
Title = IF(ISCROSSFILTERED(Table1[Region]), "Dashbaord for " & FIRSTNONBLANK(Table1[Region],TRUE),"OverAll Summary")
For KPI as Well,
Title = IF(ISCROSSFILTERED(Table1[Region]), "Dashbaord for " & FIRSTNONBLANK(Table2[Measure_Name],TRUE) & FIRSTNONBLANK(Table1[Region],TRUE),"OverAll Summary")
Hi Akhilesh,
Create seperate titles instead of Chart Title. Using below logic using DAX.
Title = IF(ISCROSSFILTERED(Table1[Region]), "Dashbaord for " & FIRSTNONBLANK(Table1[Region],TRUE),"OverAll Summary")
For KPI as Well,
Title = IF(ISCROSSFILTERED(Table1[Region]), "Dashbaord for " & FIRSTNONBLANK(Table2[Measure_Name],TRUE) & FIRSTNONBLANK(Table1[Region],TRUE),"OverAll Summary")
Thanks a lot Sandeep for this calculation.
Hi @akhiakg,
At the moment Power BI does not offer dynamic chart titles feature. There are some workarounds - you can use DAX to generate a dynamic string for the title itself and then put a card visual on top of your line chart to emulate the title. See the similar thread here: https://community.powerbi.com/t5/Desktop/Dynamic-Titles/td-p/45704 and Chris Webb's blog post: https://blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/.
You can vote for the feature here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11121882-dynamic-chart-titles-and...
HTH,
Pawel