Welcome back to my blog. Today I will be showing you how to make dynamic axis and chart titles.
The first step is to create a parameter which will be called Measure. This parameter needs will be set to three measures in our dataset, sales, profit, and quantity. Make sure you add the parameter to the sheet.
Next, you will need to make two calculated fields. One to fill the chart and another for the title. The first is a case statement so that the chart is filled by the measure selected by the parameter. The second is another case statement which will have the units of the selected measure. I will include both calculations below.
If you edit the x-axis, you can select the axis title to be the value of a parameter. You will need to select the Measure parameter to be the title.
If you now edit the chart title to include the selected measure as well as the units.
The chart is now more dynamic for the user.
I hope you have found this helpful.