Forum

Aw, thank you 🙂

Hi Karen, Thanks for your kind words 🙂 The attached files don't have any data, just headings. Can you please add some dummy data so I can show...

No, I mean literally type: = { Number.From( #date(2018,1,1) )..Number.From( #date(2028,12,1) ) } Press Enter. Convert to table. Set data type to '...

Hi C.J. You need to set the Chain field in the Pie Chart PivotTable to show items with no data as stated in step 5 of the 'Build Steps' sheet. This...

Hi Celeste, It's even easier than that. Create a new blank query. In the formula bar type: = { Number.From( #date(2018,1,1) ) . . Number.From( #...

Hi Jeffrey, I don't see why you can't do a heatmap with a PivotTable similar to this: If you're stuck, please start a new topic for the heatmap a...

Wow, that's an awesome result, Anne! Well done and thank you for your kind words and recommendation 🙂 I hope more people learn Power Query, wheth...

Hi Tykru, Not sure why those cells are misbehaving, but if you find and replace them in Power Query with null (lower case), it fixes the problem. ...

Hi Nikesh, It looks like you changed the load settings for the queries under the Transform File from Data folder. These aren't supposed to get load...

Hi Tykru, When you look at those blanks in the Power Query editor to the cells contain the word null or are they blank? If they're blank then that ...

Hi Steve, I think with this chart you'd be better off just using markers and no line. See example attached. In the line chart I couldn't tell if...

Hi Nikesh, No screenshots attached. You have to click the yellow 'Start Upload' button to actually complete the uploading of the files. You shou...

Hi Anne, Yes, you can add () to your Power Query formula to force the order of calculation, but it's not necessary for the 'if' itself, as you know...

Hi John, Can you please share a sample Excel file containing the data you have to work with (anonymized if need be). We can help you to construct ...

Hi Kathy, You're having trouble because these values aren't time, they're decimal numbers. You first have to convert them into time serial numbers ...