Edit Multiple Graphs at Once

[#1]

I have a set of graphs, a 3x7 set up, each is a single LED traffic light and it is an overview of the overall business. The expressions that go into each graph are, for example,

sum({<Category={Product1}>}[Sales (Actual)])/sum({<Category={Product1}>}[Sales (Plan)])-1

I do this for products 1 through 7, then repeat for Sales Actual vs Sales Prior Year and Sales Actual vs Sales Last Period, which gives me a 3x7 matrix of traffic lights. Is there any way that I can type this expression once then clone the graphs and simply mass-edit all of the graphs on the second line to change "Actual" to "Plan" without going in individually and changes each one? This would save me so much time!

What about, for the same graphs, is it possible to select all of them and change their ranges all at once rather than going in, individually, and changing each one?

[MayilVahanan · Accepted solution]

Hi

Try like this

Alt+Ctrl+E, you can able to see the expression overview , from that you can find/replace the field as you want..

Hope it helps

[#3]

is there a way to clone instead of copy objects?

[MayilVahanan]

Hi

In layout properties-> tick the Allow copy/clone object. From that, you can able to clone/copy the object.

or

right click the object, you can see the clone option in it..

Hope it helps

[#5]

I mean, I want to clone an object and when I paste it, I want it to be in a different location than the original (when you clone, it's slightly offset, whereas a copy-paste is in the exact same spot), but not everything seems to have Clone as an option, just Copy.

[MayilVahanan]

HI

You can drag the object and place it where you want, before that tick allow move/size in layout properties.

Suppose you want to copy to different sheet/document, right click the object, you can see copy to clipboard -> object

Then go to the sheet where you want to paste it, right click in the sheet, and select paste sheet object. And move the object where you want.

hope it helps