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.
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
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |