Forum

Hi and welcome to our forum! Unfortunately, there's no way to restrict the years displayed in the Timeline Slicer, nor is there an option to filter...

Hi Maree, The columns stepping across sounds tricky! I wonder if you'd be better off duplicating these reports, then filtering out empty rows in th...

Hi Miguel, Thanks for the images, but they're too small for me to make anything out. Can you please try again and this time don't change the size o...

Hi Nick, Welcome to our forum! Thanks for sharing your file. You can do this in Power Query (see Sources (2) in file attached) but it only has the ...

Hi Miguel, Welcome to our forum! Your question isn't clear, but I remember it from the Excel Dashboard video. Can you please upload some screenshot...

No worries, Eric. One day when you get time you can overhaul the process to be more efficient and use Power Query. It's great to know you found my vid...

Hi Tan, Please watch the video again to see how I used a different naming convention for the sheets I'm getting vs the sheet the query output will ...

Hi Eric, Like Chris said, ideally you should be doing these VLOOKUPS/INDEX&MATCH lookups in Power Query, not in the worksheet. In Power Query a...

Hi Bilal, This will be a locale issue. My dates are formatted dd/mm/yyyy and I suspect yours are mm/dd/yyyy. You need to go into Power Query and re...

Hi Tan, I'd love to but I don't have SAP, sorry. Here are some links explaining the SAP connectors available: SAP Business connector SAP HANA...

Hi Dan, Yes, you've correctly understood Anders solution. Mynda

Hi Rob, You can remove the leading/trailing spaces via the Transform tab > Format > Trim button. Mynda

Hi Steve, Sorry to hear you're having trouble loading the returns text file. I've not had anyone report that issue before. I tested it on my PC wit...

Hi Chris, Welcome to our forum. If you want the data treated as one series i.e. a continuation of the axis then you must store the data in one row/...

Hi Mohammad, Thanks for sharing the file. You can use COUNTIF for this: =SUM(COUNTIF(C3:AZ3,$C$2:$AZ$2)) You may need to enter it with CTRL+S...