Forum

Hi Debbie, If you have one table in your model that contains your customer names and you're using that customer name field in the PivotTable, and d...

You're welcome, Andrea. Glad I could help 🙂

Hi Michelle, Have you tried the DateTimeZone Functions? Mynda

In session 9.07 of the Power Pivot course I cover ALLEXCEPT.

Hi Danielle, Welcome to our forum! I'm having trouble visualising your source data, but have you tried right-clicking a value in the Sum of Feb col...

Hi Bob, Is your source data in .xslx or .csv or .txt format? I've heard there is a bug with automatically refreshing data stored in .xlsx on OneDri...

Ah, ok. Thanks for sharing the screenshot. That's an old version of Excel. That button is now called 'Data Source Settings'. Is the new source and ...

Hi Carlos, Welcome to our forum! There are notes below the video for session 4.02 that show you where the Advanced Controls are in later version...

Hi Bob, In the file I attached in my previous reply there are aggregate column measures. What did you want that's different to those already in tha...

Hi Claudine, Have you checked that the items are removed from both the fact table and the dimension tables? This should remove them from appearing ...

Hi Andrea, Welcome to our forum. I'm not sure what you mean by you pressed 'Data Origin Setup'...is that in Excel or the Query Editor. I don't h...

Oh, I see 🙂

You can try removing all filters and then setting the colours (try doing this for just 3 series) then apply the filters via the Slicer to check that t...

Hi David, You first need to pivot your data, which I've done in the attached file using Power Query - see sheet called Query. Then you can create t...

The filter icon is the drop down button on the column header. If you click on that you will have more filter options.