Forum

Hi Jim, Thanks for pointing me in the right direction. Power Query thinks the space after the course number in rows 1, 5 & 6 is a different...

Hi John, Welcome to our forum! Have you tried creating a PivotTable that contains the customer field in the Values area and setting it to Count ...

Hi Ernst, Welcome to our forum and thanks for sharing your file. This stock doesn't have data until Sep 9, 2020. If you enter this formula in a ...

Hi Jim, Can you please give me a pointer as to what the problem is. There are a ton of queries in your file and multiple tables, but I don't know w...

Glad that did the trick, Bruno!

Hi Hari, I'm sure Alan's solution works, however it requires a refresh, and I imagine you want the Slicer to reflect the OEM upon selection of the ...

Hi Bruno, Welcome to our forum! I did a tutorial on this just this week. Please watch the IF statement video here which explains that you should ac...

Hi Tom, Chart custom number formats are added via the Format Data Labels > Number pane. To enable this pane, right-click the chart labels > F...

Hi Barbara, Welcome to our forum! Please upload a small sample file containing your data so we can see how it's structured and from there we can he...

Hi Rashid, Change the data type to decimal number and then the queries can load correctly. Maybe next time you should learn Power Query from me...

Hi Tom, Thanks for providing the file and clarification as to what version of Excel you have. In the file I've attached here you'll see what I ...

Glad you figured it out, Cedric! Thanks for letting us know.

The slicer will only be able to filter the stock table where that table has the same field as shown in the slicer. e.g. if you want the slicer to filt...

Hi Cedric, There must be a non-printing character causing the text to wrap onto the next line, but without a sample file I can't help much. Can you...

Hi Tom, Please create a small mock-up Excel file containing your PivotTable and sample data. From there we can try to help you. I suspect you might...