Forum

Ah, I teach that to my Excel Dashboard course members. I use the SORTBY function to sort based on the item selected in the Slicer. If you don't have M...

Hi Andrzej, Welcome to our forum! You haven't shown how you tried to convert the ID to text, so I can't troubleshoot what went wrong there. My s...

Hi Richard, Have you tried merging the tables instead of appending? Merging will bring the matching rows together and append any new rows if you us...

Hi Eddie, I'm starting to wonder if I've correctly understood what you're wanting to do. You said "I would like to make my slicer respect the optio...

Hi Aarun, You can use SUMIFS for these calculations. See file attached. Mynda

Hi Eddie, Welcome to our forum! The sort order of the items displayed in the Slicer is set in the model using Sort By. It's not something that c...

Ok. Come back if you're still stuck after reconsidering how it should work.

Hi Jodi, Welcome to our forum! Your file didn't contain your Power Pivot model, so it's tricky to answer your question, but let me try and descr...

Hi Ruud, Welcome to our forum! Because the query and the extra column are not from the same source, i.e. all from Power Query, there is a risk t...

Hi Jessica, Your question isn't quite clear. Where is the 'x number of hours' limit stored in the spreadsheet? To back Purfleet up, I agree, Mer...

Hi Mike, Welcome to our forum! Unfortunately, your question is too vague. Please provide a sample Excel file that clearly illustrates the data y...

The only other option is to write some VBA code to handle the filtering, but this wouldn't be as smooth/quick as the timeline slicer.

Hi Maarten, Have you tried the Timeline Slicer? Mynda

Hi Philip, Please share your file and exact steps so we can reproduce the first issue and troubleshoot. As for the second issue, PivotTables ret...

Hi Rossana, I covered this in a new tutorial added to the Power Query course (2.09). Each user needs to edit the query and enter their own logon cr...