I have a graph that changes based off of parameter input. How can I make the reference line dynamic as well?
For example, I'm showing total average sales on a bar graph with different categories. This changes with parameter selection, but the reference line does not change.
Also how can I make the reference line thicker and add text to the label value?
hi Alex,
So you are all about reference lines today!!
So as per my last post...this time go into Edit!
Once there you can set the reference line to be off a measure (in my example below it's set to the SUM of Stock Units)...this way it moves when the data does.
and I've highlighted where you can change the line thickness.
To add text,,,you can change the label to custom
where you can add some text, and then use the little right arrow to add a dynamic field...so in the example above it will say "SomeText" followed by the SUM of Stockunits value...there are a few other dynamic options (such as measure name)
