Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can I detach a chart without showing the word 'detached'?
I do not know if it's possible. But as an option, you can remove the title bar and put the title in the chart.
I guess what is the reason behind detaching this chart? You don't want the values to change based on selections? Use Set analysis {1} for that may be
yes. Is detach the only way to make it static ? Buy the way, how to use Set analysis {1}, can you give an example? sounds interesting.
Hi,
Please Share your expression used in detached chart, we can help to convert into set analysis expression.
So lets say you have two expression in your chart
Sum(Sales)
Sum(Cost)
You can make your chart static by adding {1} like this
Sum({1} Sales)
Sum({1} Cost)
Now, any selection in the dashboard won't impact for this particular chart
I need the chart title to stay, but I don't want to see (detached) when I detached a chart.
Also check out these links for good understanding of set analysis:
I had the same issue. One work around i found was:
=[CY]&' '&'Look Ahead'&' '&CHR(10)
Add CHR(10) at the end of your expression. Works fantastic for me