Mike, I agree with you it would be really handy if the title box in the edit axis dialog accepted parameters, unfortunately it doesn't. The only workaround (not much of one) I could come up with was using annotations in the chart (see attached).
Annotations.twbx.zip 1.1 MB
Thanks Shawn, I will take a look at the example and give it a try.
Wow, that's a hack (in the positive sense). Nice work, Shawn!
Shawn, that works brilliantly - thank you!
Here's what I have done in the past to handle this:
1. Create the Scatter Plot with the calculated fields based on the X and Y axis parameters
2. For both axes, make the Title and Sub Title blank.
3. Add the Scatter Plot to a dashboard.
4. Add text boxes where the axis labels would be.
5. Set the text boxes to read the parameter value.
6. Format the Y-Axis label to be oriented vertically.
DynamicScatterplotLabels.twbx 1,001.9 KB
Hi Mike - I was curious if the workbook I uploaded was helpful for you.
Shawn Wallwork - Do you know if there is already an idea created for supporting a Parameter Value in the Title Box? I would love to hear your thoughts on the workbook I uploaded as well.
We can create another report where we can use Parameter only, then we can
add original Report & Second report ( Only Parameter).
On Fri, Feb 27, 2015 at 9:41 PM, Shine Pulikathara <
1 of 1 people found this helpful
Shine, if you mean the axis title box then I'm not sure. I might have created one several years ago. kettan will know.
As to your sample viz I use this same technique you're using, especially now that we can float things into position. I personally don't care for sideways text, so I avoid it whenever possible. This is the typical way I handle axis labels:
This is the way I do it. I bring the Parameter into the Row (or Column) Shelf (which is discrete), and then hide the Field Row Lablels, and Change the Axis Label to Blank.
It doesn't work for Dual Axis, but has served me well!!
Btw if your parameter is actually an integer, say, with an Alias, you need to create another calculated field along the lines of
CASE [Selected Measure]
WHEN 1 THEN 'Sales'
WHEN 2 THEN 'Profit'
and then bring this in.
A bit more complicated is the one for Scatter Plots, as the this method puts the X-Axis Label (we've created) across the top, with the Axis ticks along the bottom. My solution for this, is to Copy the axis, and then Dual Axis them (sync Axis...of course!). This now gives me an Axis along the top and bottom (for X Axis). I then Remove the Axis Ticks for the bottom one, and then the usual hiding of Row Headings...etc.
Hope this helps.
Dynamic Axis Labels.twbx 593.5 KB
- Create a dashboard.
- Add a textbox below or beside the axis you want the parameter value to populate.
- In the textbox insert the <parameter> and you're done.
Of course, as soon as I wrote this I realized that Shine Pulikathara suggested this same method back in Feb. Well done Shine!
5 of 5 people found this helpful
I just came up with yet another workaround for this that turned out quite nice. Turn on caption for the worksheet and remove the default text. Type in something like " Top <parameter value> Customers by <parameter value>". Be sure to center it.
The remove the default label for the x-axis.
When I run it, i get "Top 10 Customers by Sales Amount" when I select that measure from my parameter for the chart, or I get "Top 10 Customers by Revenue Amount" when I select that measure.
What a smart and creative solution, and many thanks for coming back to the thread to share your findings...
So I've set up the sheet as per the below (the Blue pill on Y Axis is just the parameter, and the Caption used the X-Axis parameter)
when we put this is a dashboard...it looks seamless (as we loose the 'Caption' header)
Sir...you are genius! thanks again