Last seen: Jun 22, 2026
Great to know that did the job and that you're benefiting from the course 🙂 Don't be put off trying to figure things out for yourself though. Often ...
Hi Sunil, Why don't you use the Filters to filter the PivotTable/Chart to show the date range you want, rather than writing a complicated measure? ...
Hi Austin, Welcome to our forum. Please note that it is polite forum etiquette to be transparent when you post the same question on multiple forums...
Hi Ahmed, I don't see what the problem is. If I remove the trend lines and then add them again in the chart settings I can change the selections in...
Yep, that'll work too 🙂
Hi Ahamed, Welcome to our forum. Please explain in words what your question is. Many thanks, Mynda
Hi Mariena, Welcome to the forum! You haven't provided enough information, but presumably you have a date dimension table and the Slicer is usin...
Hi Adriana, Since File 1's Material column contains both letters and numbers you need to set the data type as text. Therefore, you'll also need to ...
Hi Dritan, That's a shame because you can use dynamic arrays available in Office 365: =TEXTJOIN(", ",TRUE,(IFERROR(UNIQUE($B$5:B19)&" | "&am...
Hi Dritan, What version of Excel are you using? Mynda
Hi Amaro, It's great to see you're having a go at building your own dashboards. Please see answers your questions below: 1. You have inserted a ...
Hi Bob, You haven't mentioned where it's requiring/requesting Administrator permissions, but this post might point you in the right direction. M...
Hi Raf, You can use a PivotTable and group the dates. See example attached. Mynda
Hi Vivian, Hard to say without seeing what you've done. Can you share the file? Mynda
Hi Aye, That's how I'd do it too. Mynda