Forum

Hi Sara, Welcome to our forum! If you use proper date serial numbers in your chart you can set the date axis units to Major in 7 or 14 day grou...

Hi Charmaine, Welcome to the forum! I suspect it's caused by some regional settings on your PC. This post explains more about Power Query date s...

No, Slicers aren't available for Calculated Fields 🙁 Maybe you'd be better off adding a helper column outside of the PivotTable that checked the Max...

Hi Alan, Probably not ideal, but you can add a Calculated Field to find the Max of each date's M1, M2 and M3, then filter on that field. See exampl...

Hi Michael, Not that I'm aware of. Have you tried Protecting the Timeline and then using Worksheet Protection? Mynda

Hi Kevin, It is filtering all types for top 10. The problem is that you have ties in your data and when there's a tie, all tied results are display...

Hi Larry, Thanks for sharing your file and data. I see that your data layout is not tabular. First, you need to unpivot the data. In the attache...

Hi Samantha, Thanks for sharing your file. You can use INDEX & MATCH array formula for this as explained here. See sheet 3 of the example file a...

The PivotTable will automatically only include the suppliers that have data according to the filters set in the Slicer.

Hi Brian, Yes, you need to summarise your data in a PivotTable (not a table), but first you need to unpivot it, which I've done in the attached fil...

Hi Aye, Tables and Power Query cannot have dates in column headers. This layout you want is not a tabular format. This is something you should do a...

Hi Samantha, Can you please upload a sample Excel file as it's difficult to follow from the images and I don't have time to try and recreate all of...

Hi Jace, If you want the filtering to dynamically update depending on the filters selected (gender, race, region) then this would be best done in P...

Hi Mardi, Are you using a date table for your PivotTable date fields? When you use a date table you set it as such and mark the date field. In the ...

Hi Brian, Without an example file I'm not sure exactly what you're referring to, sorry . If you're strictly talking about data labels and they show...