1 chart works, 1 chart doesn't work...but they're the same chart!!!

[m5edward]

Hi All,

I work for a retailer with multiple banners. I made a BI report for all these banners by copying the first banner's slide multiple times and changing the filter.

Everything worked fine for many months, but now the 'Avg Store Size' column works on the first banner, but not the others. But they are the exact same chart, puling from the exact same data, but with different filters.

Any ideas?

Thanks,

Mark

 

[BSALV]

the formula is deleted or points to the wrong range ???

 

[m5edward]

the formula is deleted or points to the wrong range ???

My apologies, but I'm not sure what you're asking me.

 

[m5edward]

Update: It has something to do with dates. When I take the date filter off it works, when I apply a date filter it stops working. But my first banner still works regardless of the date filter.

 

[BSALV]

go to your first banner and with (in the ribbon) Formulas>formulas evaluate, go step by step through the formula and notice how it works, which cells he refers to, etc.
Do afterwards the same on a non-working cell and find out why that one isn't pointing to the right range.

Until now, you give no real information that was of any help.

 

[m5edward]

go to your first banner and with (in the ribbon) Formulas>formulas evaluate, go step by step through the formula and notice how it works, which cells he refers to, etc.
Do afterwards the same on a non-working cell and find out why that one isn't pointing to the right range.

Until now, you give no real information that was of any help.

I am using Microsoft Power BI. Are you talking about Excel?

 

[BSALV]

yes, sorry.