Forum

Hi Alison, I wrote this formula and it returned the correct results for Dept A: =SUMIF(Sheet1!$B$5:$B$15,'Dept A'!$B$1,OFFSET(Sheet1!$B$5,,MATCH...

Yes, that's how line charts plot missing data and I'm not aware of any option to change it. The reasoning being that you need two points to create a l...

I'd just have a drop down somewhere in the workbook that allows you to choose the month you want the charts to display up to. You can reference this d...

Hi Oracle! Write a measure that sums the values and where the result is =0, return BLANK() e.g. Line Chart Values = IF(SUM(FactTable[Sales])=0, ...

Hi Lea, Actually, you can omit the -1 and just use the < logical test. I just applied a filter on the date column using filter drop down on t...

Hi Paul, You need to set up dynamic named ranges for the chart source data. For the Sparklines, you can use a relative dynamic named range. Note: t...

Hi Alison, You need to use a dynamic named range in the SUMIF sum_range argument. Note: it doesn't need to be a 'named range', you can just insert ...

Hi Lea, I couldn't use your file because my Power Query wouldn't work with your Hebrew data, but you can use these functions as the Power Query equ...

Hi Junko, Looks like your file didn't get uploaded. Please click the yellow 'start upload' button after selecting your file. Mynda

Ah, yes I am using Office 365. Glad you figured out the problem and thanks for sharing.

Hi John, I don't get that error, but you can just edit the measure and change the function from COUNT to COUNTA. Mynda

What do you mean by 'upload', where is the data coming from and where do you want it to go?

Hi John, Thanks for uploading the correct file. The date format appears to have already been fixed in your source data, so I can't help you with an...

Hi Matthew, You would need to set up the measures first. Going back to my original suggestion now that I have your sample data. I don't see why you...

Hi Ken, You can use Pivot Chart expand/collapse buttons to get a similar effect to what you're after. Mynda