Forum

Hi Marc, I'm not having any problems with that button. Have you tried opening the query editor and expanding the queries pane on the left, then rig...

Clever is Mr Peltier 🙂 thanks for sharing, Blanka.

Hi Dick, If you go to the PivotTable on the Masterdata sheet and change the timeline to show 'Years' you'll see that it is filtered to 2019 only. W...

Hi Mohinder, Looks like there are some problems with authentication at the moment. More is explained here along with some workarounds. Mynda

Hi Blanka, You can't automate the formatting you want for the column chart. Better to stick with the line chart or write a macro to change the form...

Hi Nilesh, It looks like you've already set up most of the rules. I noticed the first rule had a % sign after the second cell reference in the form...

Hi Mohinder, You only get this dialog box the very first time you connect to the web page and after that it remembers your choice. You needed to se...

Hi Mohinder, When you enter the web URL the next dialog box will ask you how you want to connect to the page and whether you need to enter any cred...

Hi Aye, It's in the Unpivot lesson. See file attached. Mynda

Hi Ron, You can write a Power Pivot DAX measure to count blanks: =COUNTBLANK([YourDateColumnName]) Mynda P.S. great to know you enjoyed th...

Hi Colin, Not much we can do to help as it seems your install of Excel has bugs. Are you able to use a different PC, or perhaps change your update ...

It's odd indeed, Colin, but at least you have a workaround for now. Hopefully next month's update will fix it. Mynda

It must be something with the install of Excel you have. What update channel are you on? Go to File tab > Account. Under the version number it will...

Thanks for your kind words and spreading the word about us! We sincerely appreciate it. 🙂 What a shame yesterday was a waste of your time.

Hi Colin, Is the pp3_Products.xlsx file closed? Power Query can only get data from closed files. Also, have you tried getting data from any othe...