The new DAX window functions (announced here, more details on Jeffrey Wang’s blog here and here) have generated a lot of excitement already – they are extremely powerful. However one important benefit ...

I love Excel as an alternative to Power BI reports, especially now that Excel Online allows you to interact with browser-based Excel reports that use Power BI datasets or the Excel Data Model (aka ...

If you want to be a true spreadsheet power user, you need to learn about the Power Query and Power Pivot features in Excel. While you can get a lot done with Excel alone, using these built-in “Power” ...

How to convert a Microsoft Excel slicer into a series of filtering buttons on a PivotChart Your email has been sent PivotCharts and slicers go together like peanut butter and jelly — the slicer ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

This is an External Tool for Power BI Desktop to connect Excel to the local model hosted in Power BI Desktop. The goal is to be just one click away from an Excel report. While the initial version must ...

Please note: This item is from our archives and was published in 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Because the field names ...

Have you found this content useful? Use the button above to save it to your profile. Simon Hurst continues ExcelZone's Five Minute Pivot Tip series with a look at the layout options for PivotCharts, ...