Forum

Hi Laura, Thanks for the file. That makes it much clearer. It doesn't matter if the field is null or zero, you can use the filters on the visual, r...

Great to hear you're enjoying the course and managed to fix the issue, Peter!

Hi, Welcome to our forum! You can change PivotTable aggregation methods using Slicers as explained here. You do need separate measures for the ...

Hi Alwyn, Like Anders said, your month headers for P4 on row 23 are not entered correctly. They have a leading and trailing space in each cell. You...

Hi Chris, Welcome to our forum! I already answered this question on YouTube where you posted it originally: First split the column by position ...

Hi Philippa, Create separate PivotTables for each chart so that the chart you don't want zero values displaying doesn't include pipeline data. You ...

Hi Laura, Welcome to our forum! It's almost impossible to keep in mind all of the details you covered in order to form a picture of your data in...

Hi Peter, Welcome to our forum! To clarify and using the Contoso example from the course, let's say you have a filter applied to the Gross Profi...

Hi Francis, Your file didn't upload properly. Please try again and be sure to wait for the 'upload completed' text to appear in green under the yel...

You're welcome 🙂 There's a link to our channel in the post above (edited).

Hi and welcome to our forum! I'd say the 'Total Sales' field has been renamed because usually it will say 'Total Sum of ....'. You may be referenci...

Hi Philippa, It's not clear what field your Slicer is for, but by default a PivotTable will only show items that have values in the source data. If...

Hi Brandon, We too have an Excel YouTube channel! You can consider every question on the forum as something people are struggling with 😉 Be su...

Hi Maarten, Welcome to our forum! If you can use regular PivotTables you can simply edit the Field settings and check the 'Show items with no data'...

Hi Trond, To answer Q1, yes, but you should make these proper dates and then create a date/calendar dimension table so that you can insert a Slicer...