Forum

Hi Melanie, It's not clear what you're wanting to do. Can you please provide an example in another sheet with manual shading applied so we can see ...

Hi Trond, I'm afraid you'll have to embrace DAX for the best solution, anything else would be manual. Here is a step by step tutorial explaining wh...

Hi Christoph, This is a limitation from Salesforce, not Power Query. i.e. Salesforce will only return 2000 records. Mynda

Welcome to our forum, Karlis and thanks for your contribution. My understanding of Matthew's issue is that he's using an Excel Table to feed the ch...

Hi Safirah, It's impossible to know what the problem is without seeing your file. You can share it with my via email, or if it's too big for that t...

Hi Dan, That's odd indeed. I never experienced that problem. I suspect it is a short-term bug that will be cleared with an upcoming update. Can you...

Hi Stefano, Yes, you use the From Web connector and the SharePoint file path. Mynda

Hi Roxana, There was no file attached, but my guess is that your file had PivotTables in it and the ranges referenced by the PivotTables need updat...

Hi John, When you edit the data source the range field becomes active and I just used my keyboard down arrow to extend the range by another row, bu...

Hi Sammantha, Please supply the workbooks otherwise it's nigh on impossible to give you an answer. Regards Mynda

Hi Deborah, Yes, correct. Regions filters customers and customers filters orders. Mynda

Hi Aye, You could try applying a value filter to hide values < zero, but I'm not sure this will work where you have balances in the months leadi...

Hi Alan, COUNTIF requires a contiguous range, so no, you can't just check specific cells unless you write separate COUNTIFS, but I don't see why yo...

Hi Matthew, Unfortunately, there is no drill down to the row level of detail functionality like we have with Excel PivotTables. The best options yo...

Hi Maja, Thanks for fixing the data. Please see attached. Is that what you want? Mynda