Forum

Hi Mardi, Yes, in theory you can add columns in Excel beside the Power Query table and when PQ refreshes it won't remove the data, but it's a bit r...

Hi Lydia, No, Power Query can only output data to a single file i.e. the file containing the query. You'd need to create 50 separate query files in...

Hi Jessica, Welcome to our forum! No is the short answer. PivotTables only retain/get data from the source data table. You'd be better to create a ...

Hi John, Great question. Your date table should be from 1/1/08 through to 31/12/15 i.e. it must cover all periods and it you want to use Time Intel...

Thanks for the file, Chris. If you can't show me what you want the end result (report) to look like, then I can't do much to help, sorry. From what yo...

Hi Ahamed, When you programatically apply a label it doesn't respond to changes in the PivotTable. i.e. when you add a label using a macro. You nee...

Hi Chris, Thanks for the file. First, you can't use a PivotTable as the source data for a table in a Power Pivot model. You need to use that PivotT...

Those images appear blank. But don't worry as I've given you the solution in the link above.

Hi Sunil, You can change the view of the timeline to aggregate by year, quarter or month. Click the drop down button beside Month in the timeline. ...

Hi Chris, Please try uploading the file again as it's not attached. You need to click the yellow 'Start Upload' button after selecting your file an...

Hi Sunil, Attached is an example file based on your data. You can use a Timeline Slicer to select the period you want to display. Then hide the sli...

Hi John, Welcome to our forum! You can't customise the QAT in Power BI at all, sorry. Mynda

Hi Mark, You haven't been clear about what is not working properly, but I'm assuming it's the totals not adding up as you'd expect. If so, right-cl...

Hi Ahmed, It's a little clearer, but for future reference, the images are still way too small. I don't need to see your whole screen, just the rele...

Hi Sunil, Again, you didn't attach a sample file, so we don't know the format of your data. If you want help, then the quickest way is to take a bi...