Forum

Hi Steve, From what I know about the current priorities for building new chart functionality, I'd say the chances of Microsoft building a new Pivot...

Interesting...when you display both vertical axes the scale for the two series changes so that the 740 column is higher than the 795 column. I turned ...

Hi Eric, Maybe what you need to use is Power Pivot to create relationships between your tables using the Case# field. However, like Phil mentioned,...

Sneaky trick, Sunny 😉 The only problem I see is that the primary and secondary vertical axis aren't to the same scale for Riviera school and Fran...

Hi Steve, Thanks for sharing your file and example chart. Unfortunately, Pivot Charts are not flexible enough to enable you to build this chart. If...

Hi Jennifer, Why don't you just put the gender in the filter field and filter for Female? Mynda

Hi Jessica, There's no workaround that I'm aware of. Perhaps you can create a field that you can sort numerically e.g. mm-yy or if you'll have mult...

Hi Jingjing, It sounds like you're watching the old version of the course which was recorded before we had the new histogram charts available. You ...

Hi Bax, The quickest file type to import is a .csv or .txt file. Seeing that you only have one sheet in each file, why not change the file types to...

Hi Riny, Thanks for helping out. Please try uploading your file again. You need to click the 'Start Upload' button after selecting your file, then ...

Hi Bruno, I suggest you always have some dummy data in your data model that you can use if the current month data is empty. It likely only needs to...

Hi Else Marie, You can use a nested if formula: = if [Type] = 1 then [Date] else if Date.DayOfWeek([Date], Day.Monday)>5 then Date.AddDays([D...

Hi Paul, Please start a new topic for a new query as this is more likely to get an answer than burying it on the bottom of an old post. I've moved ...

Hi Pooyeh, Welcome to our forum! PivotTables do not respect the sort order of the source data. By default they sort in alphabetical order based ...

Hi and welcome to our forum. You can add a column to your table to calculate the running average per fund using the AVERAGEIF function. Note: your ...