Last seen: May 15, 2025
Hi Ronald, The Region and Departments in the Parameter table are looking for data validation lists that aren't there. My bad, I didn't clear them o...
Hi Ricardo, It's inefficient to nest XLOOKUP like this: =XLOOKUP(C11,'Ambient 1'!$E$3:$E$10,'Ambient 1'!$F$3:$F$10,XLOOKUP(C11,'Ambient 2'!$E$3:...
Hi Alex, You can't conditionally format the Sparkline line. The best you could do is colour the cell fill for that Sparkline using conditional form...
Hi Robb, Have you tried right-clicking one of the value fields in the PivotTable > Show Values As > % of Parent Row Total? Mynda
No, Power Query cannot refresh password protected files.
Hi Ron, The message screenshot didn't upload. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside...
Hi Ronald, The new/updated version of the Power Query course doesn't include a Notepad++ file in the practice materials. That's only available in t...
Hi Dario, Great to see you're practicing. There is an alternate file under the video for that lesson that you can use. Be sure to check for notes u...
Hi Kauser, Welcome to our forum! Thanks for sharing your file. The structure of the data is not suitable for PivotTables. It should be in a tabular...
Hi Farshad, The tone of your email does not come across well. If you would like an answer to your question, it is courtesy to provide some data you...
Hi, As you've found, it's not possible to include a Sparkline in a PivotTable. Please see this tutorial on relative dynamic named ranges. Towards t...
Hi Tyrone, Thanks for sharing your file. Your formula is referencing the wrong cells. It should be as follows: On the Gender Selection Images sh...
Hi Sarfraz, I would use Power Query to bring the data in from the PDF and then tidy it up from there. Once you do this the first time, you can re-u...
Hi Azin, Welcome to our forum! Please provide an example file showing what you mean so we can help you. Mynda
Hi Tyrone, You could add an IF formula in say, cell H2 that says if there is data in cell G3 i.e. the slicer is either filtered for more than one s...