Forum

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 ...

Hi Peg, Welcome to our forum! It sounds like you're using all the relevant tools for protecting your data integrity. Obviously, you can't preven...

Hi Lenka, Welcome to our forum! Correct, the data split over multiple sheets means you cannot connect a single slicer to each PivotTable. Instea...

Hi Doug, You can use INDEX & MATCH with COUNTIF for this. See file attached. Mynda