Last seen: Jun 30, 2026
Hi Daniel, Thanks for sharing the image. That helps me properly understand what you're working with and how your PT is set up. When you select a...
Hi Daniel, In session 7.03 I share some VBA code that will automatically refresh PivotTables when the focus is shifted from the sheet containing th...
Hi Baxbax, Does this have to be done in Power Query? It's easy with a PivotTable - see attached example. In Power Query it's much more complicated ...
Hi Blanka, The only way to deal with this is to make the chart bigger overall, or make the bar area smaller to allow more room for the axis labels....
Well done figuring it out, Blanka. Since Power Query doesn't apply formatting it makes sense that any number that starts with a zero cannot actuall...
Hi Rath, That formula doesn't work on your example data. What did you mean to write? Mynda
Like I told you originally, Rath. With a helper column to consolidate the Dr & Cr into one column then you can use this technique: See soluti...
Well done, Sunny. Nice, elegant solution.
Hi Blanka, Great to see you're having a go at writing formulas and finding solutions. An alternative is to use the function Text.PadStart to fix th...
Hi Valerie, You seem to be confused about how to use the forum (did you see the email Phil sent you with instructions?), as you're still creating m...
Hi Toby, It is well known among the Excel MVP community that running Excel 2013 and 2016 side by side can lead to major problems. I have installed ...
Hi Toby, I did some searches on Google and there seems to be a plethora of possible causes. Without knowing more about your system it's difficult t...
In that case you should be able to manage relationships via the PivotTable Analyze tab in the 'Calculations' group > Relationships. You dont' have ...
Hi Moira, Yes, in Power Pivot you drag from your fact table to your lookup table (dim table). Just as though you might write a VLOOKUP formula in a...
Hi Samuel, If you insert a linked chart then you can refresh the charts in the PowerPoint presentation to have them automatically pick up the updat...