Forum

Now that we have the VSTACK function we can return headers like so: =VSTACK({"Header1","Header2","Header3"...},FILTER(....your filter formula)) ...

Hi Zaki, I agree with Jessica. I'm not sure where you'd plot the line for >5 and <1 and it be clear what it represents. It would be helpful i...

Hi Dieneba, For a Slicer to be able to filter multiple PivotTables, they must all use the same source data. If you have 3 separate sources, then yo...

Hi Kelli, Thanks for sharing the screenshot. I can see why you are confused. There are two primary Power BI tools so to speak. An online Power BI w...

Hi Alan, Hard to say as I can't see the row and column labels in the screenshot to reference it to the conditional formatting rule. Perhaps you hav...

Hi Tom, Thanks for sharing the screenshots. It must be a regional setting. You would have to switch to an English version of Excel by changing the ...

Hi Kelli, Attached are screenshots of my screen with the navigation pane collapsed and expanded (saved in one image, side by side). In the collapse...

Hi Dieneba, Let's say you have a dashboard that has multiple Pivot Charts (connected to PivotTables) that display sales data for a group of departm...

Hi Ruth, Welcome to our forum! Microsoft in their wisdom changed the name of the From Table/Range button to From Sheet. Then after much backlash...

Hi Alan, When using conditional formatting with PivotTables you need to set it up in a particular way which is described in this tutorial on conditi...

Hi Dan, You can combine all or select workbooks in a single folder, or you can combine all or select sheets in a single file. However, if you want ...

Hi Dieneba, Slicers apply filters to PivotTables. The PivotTable Connections dialog enables you to specify which PivotTables you want that Slicer t...

Hi Michele, There's currently no way to link the minimum start date on the horizontal axis in your chart to a cell and because of the way the chart...

Hi Doug, Why would you want to model it in VBA when a formula does the job? I recommend avoiding VBA unless absolutely necessary. Typically built-i...

Hi Felix, Welcome to our forum! Unfortunately, there's no way to specify the background colour in the Power Pivot window. That was filmed in an ...