Forum

Hi Nawaf, You can't do this in Power Pivot, but you can with Power Query. This tutorial on numbering grouped data in Power Query should point you i...

Hi Steve, That looks like a bug. When I create a new filled map visual now it also shows the labels behind the data! I'll report it to Microsoft...

Hi Prem, Excel doesn't understand "So It should cover up little more than the tag amount." Little more isn't something Excel can evaluate. You must...

Hi Pedro, Like Phil said, please attach your workbook. It sounds like you're trying to build a cell reference using a formula, but you haven't wra...

Hi Cristina, This post covers sorting options in PivotTables. If you have a lot of items to sort then these options may not be ideal. In which c...

Hi Masashi, Yes, PivotTables automatically re-sort upon changes in Slicer selections (filters) or new data being added to the source. More on sorti...

Hi Qadeer, Welcome to our forum! Your dashboard is structured a little different to mine in that you don't have the days completed. You can cond...

Hi Daniel, If you want to filter by multiple parameters you need to create a list, which you've done with APIFiltered, then you can use the List.Co...

Hi Rajiv, Thanks for your best wishes on YT. It's been amazing to have the support of so many people. In the homework_completed_365.xlsx file th...

Hi Rajiv, Great to hear you're enjoying the course. The challenge I have in creating new dashboards is getting sample data to use. If you have any ...

Hi Masashi, I would use PivotTables for this task. You can use the built in sorting capabilities and the conditional formatting etc. Formulas are e...

Glad you figured it out, Rajiv. The code will be triggered to refresh all PivotTables when you change focus from the sheet containing the source da...

Hi Daniel, Please see lesson 7.01 of the Power Query course on Parameter Tables for Filtering. If you're still stuck, come back with your file show...

Hi Luke, Q. -->Is there a way to limit the data range (date) while creating connection to MS SQL Server? & --> Is there a way to chose gi...

Hi Rajiv, You have only put the first piece of code in your file. You're missing the second code that should be in the 'ThisWorkbook' object for th...