Forum

Hi Richard, I see you have Slicers so these are obviously PivotCharts. You can use a filter on the Month field to select the specific date range yo...

Hi Islam, Please don't quote my reply again. It is directly above your reply so is not necessary. I've removed it from this post. Thanks for cla...

Hi Pieter, In that case, make the Towns table your fact table and remove the AreaID and Town Name columns. And make the Dim Alloc table also contai...

Hi Islam, Thanks for sharing your file. If I'm understanding correctly, you want to use the PSD sheet as an input form that then copies the data to...

Hi Pieter, You're right, you didn't structure your model correctly. The Towns table (your fact table) should contain the Area ID column. That makes...

Hi Leslie, The reason you're having problems is because the file is not structured correctly. In order to use SUMIF your data should be in a tabula...

Hi Cristina, It's not clear from your file or description where exactly the figures are coming from but presumably it's the individual week tabs. I...

Hi Cheryl, I have also found this with SharePoint. I'm not aware of an easier way to enter the file path rather than the SharePoint root directory....

Hi Peter, Welcome to our forum. You can't vertically append ranges using the ampersand. I would use plan B 😉 Mynda

Hi Erik, Have you set the Slicer to sort using a custom list (I presume that's what you mean when you say 'I have made a list in settings'). Als...

Hi Christina, Thanks for sharing your file, however I don't know which sheet(s) or what to look at in it. I'll assume it's the 'Deviation forecast ...

Hi Kenneth, Yes, get the data with Power Query. In the Power Query editor window, select the 10 columns you want > right click: remove other col...

Hi Pieter, That still doesn't sound right. Please try attaching your workbook again. You need to click the yellow 'start upload' button. Mynda

Hi Claudine, This is how the 'show data point as table' is designed to work i.e. as a temporary table. If you want something more permanent, then c...

One at a time I'm afraid, Katherine 🙁 Unless you can write some VBA to automate it, or you could select the cells > Home tab > Clear formats.