Forum

Hi Scotty, There was no attachment. You need to click 'Start Upload' after selecting your file and then wait for the grey check mark beside the fil...

Hi Valerie, Yes, a line chart. There's no specific s-curve chart, but essentially it's a line chart. You'll have to write a measure to generate the...

Hi Grete, It's difficult to say without seeing some sample data, but my initial thought is you have too many tables. Dim tables are for data that i...

Hi Michael, If your data is in Excel file A and you use Power Query in Excel file B to get the data and load it direct to Power Pivot, then you can...

Hi Olesea, The process for getting files from a local folder vs a SharePoint folder are different, as you have found. Because of this you can't sim...

Hi Matt, Welcome to our forum! I've moved your post to the Dashboard Course members forum so it gets priority. Without seeing your dashboard and...

Thinking about this a bit more, I wonder if it's a Table feature. Tables are designed to copy formatting and formulas down a column. This is best prac...

I agree it seems like it should, however the fact that it doesn't when it preserves all other formatting suggests to me that maybe cell alignment form...

Hi Michele, In that case, select a range of cells 3 rows high and 5 columns wide, then enter this formula: =INDEX(Table1[[Project]:[Status]],SMA...

It's preserving the alignment if the rows within the table are the same because it's not actually loading anything to Excel because there's nothing to...

Hi Micheal, The problem you are currently having where you have to refresh twice to get the PivotTables to update is caused by loading the data to ...

Hi Michele, You didn't mention what version of Excel you have, so I have assumed you have 365, in which case you can use this formula: =CHOOSERO...

Not sure, Tony as it's difficult to say without seeing the file. It does seem like something is wrong if it can process it in 10 minutes upon opening,...

When Power Query gets new data it also gets the original data again, so in effect it's replacing the data that you've formatted. Not sure why it's not...

Hi Michael, Just to be sure, the query should get the data from the external data workbook and load it directly to Power Pivot/the data model in th...