Forum

Hi Robert, Welcome to our forum! Yes, you can have an input field on the dashboard itself, which you then reference in your formulas that build ...

Hi Lisa, What do you mean by 'reflect the start of the project' exactly? The conditional formatting in my file reflects the start to the finish by ...

Hi Salim, I understand what you want, but if Pakistan isn't in the list of supported country exchanges, then you can't just add it and there's no o...

Not easily, no. Especially if you don't have Office 365 and dynamic arrays. I would just make the Slicer as small as you want, then the user can use t...

Hi Gregory, Thanks for the screenshots. You need to perform the Changed Type > using Locale step in the 'Sample Query'. Mynda

Hi Maria, Why don't you use a Pivot Chart and Slicers to choose the Account Manager. See attached. Mynda

Hi Salim, You haven't said what your country is, but if it's not in the list I linked to above, then there's no way you can add it, sorry. Mynda

Hi Liam, It would have helped if you had shared a file to save me having to manually create it. See running total formula attached. I hope that hel...

Hi Gregory, Welcome to our forum! There's no file attached. Please click the 'start upload' button after choosing your file to upload. That said...

Hi Salim, Here is a list of supported stock exchanges. Try prefixing your stock code with the market code, followed by a colon, then the stock code...

Hi Marsil, There's no conditional formatting in charts, so you need to create 3 separate series, one for each colour. See example file attached. Yo...

Hi Indu, You need to right-click the Slicer > Report Connections and then select all the PivotTables in the list that you want that Slicer to fi...

Glad you found it, Andrew. That is the only solution. Power Query is expecting the same file layout and has these references hard coded, so if there's...

Hi Lisa, Glad I could help. Yes, you can base the dashboard off the start dates instead of the end dates, you'll just need to edit the formulas ...

Hi Andrew, Is the sheet name in the new file the same as the old file? This is important too and the likely cause of the error. Mynda