Forum

Hi Daniel, Welcome to our forum! If you're loading the data from Power Query to Power Pivot then the relationship is created in Power Pivot. If ...

Hi Javier, Thanks for sharing your file. The formula in my example expects the Sparklines to be on consecutive rows. Your Sparklines have two spare...

Yes, you're telling PQ the format the data is in. PQ already knows your locale so it knows the format you want it in. In terms of formatting dates...

Hi Carolina, Welcome to the forum! Did you choose Data Type 'Date' and Locale 'English (United States)? I just tested it again here and it works wi...

Hi Javier, Welcome to our forum. Please attach your file again and this time be sure to press the yellow 'Start Upload' button. Mynda

Hi Nawaf, Welcome to our forum! When you filter the PivotTable using the Slicer it is not refreshing the query. To do that would take even longe...

You might be on a slower update channel. It's now available on the Monthly channel. Your IT people should know how to update it to the Monthly channel...

You're welcome, Emil. It all comes with practice and you're practicing, so that's the most important thing 🙂

Hi David, It's a little worrying that your IT department have the wrong information! The Get Data from PDF connector is an update only available...

Hi Emil, Welcome to our forum! It's great to see you're having a go yourself. You can simplify the query by using Split Column by Position. See exa...

Hi Yesintha, When you get data from an external Excel file, that file must be closed for Power Query to get the data. You're getting that error bec...

Hi Jason, Sounds like you need to update your install of Office. Go to the File tab > Account and click the Office Updates button. You may need ...

Hi Dave, Welcome to our forum! You can do this with a PivotTable and Slicers. Start with the following columns: Contact Name Company Indu...

Hi Minki, In that case why don't you leave the filter button on the Pivot Chart and allow the user to filter with that, which is searchable? It wil...

Well done, Erik! I'm sure you won't forget how to do it in future 😉