Forum

Hi Dieneba, DAX functions enable you to create measures and calculated columns on data in Power Pivot/Data Model. To do this with a regular Excel f...

Currently, the only way to access data from a query is to load it to a cell in the worksheet, or load it to a PivotTable or the Data Model. You cannot...

Hi Keith, If you've already loaded the query, then you don't have the option to change the 'to' from the query editor. However, if you open the Que...

Hi Brett, Map charts require you to summarise the data into states or countries. You can do this with a PivotTable and then build a regular chart f...

Hi Deirdre, If you make the chart small enough, the labels will automatically wrap., but they are also centered and there's nothing you can do abou...

Hi Wesley, If you wanted to reference anything outside of Power Query, you have to load it to the worksheet. If the average score is something you ...

Hi Jay, Depending on the version of MYOB that you have, there are some connectors available: - Power BI Odata connector - MYOB Advanced Conne...

Hi Sayeed, Your question isn't clear, sorry. I don't see anything called 'green water footprint' and I'm not following the flow of data from where ...

Hi Sayeed, Your file didn't get attached. You need to click the yellow 'start upload' button after selecting your file and then wait for the grey c...

Nothing attached, Jim. Please click the 'Start' button after selecting the file and wait for the grey check mark beside the file size before clicking ...

Hi Michael, The units table sounds like it's a fact table, not a dimension table. I recommend you create a proper dimension table for the accounts ...

Sorry, Sally, but I need the source data in an Excel file, please. If it's sensitive data, you can strip out everything but the x axis labels and the ...

Hi Sally, Can you please upload an example Excel/Power BI file. My brain stopped visualising your description after the first sentence! Thanks, ...

Hi Richard, I would say that unless you're having performance issues with your data structured the way it currently is, or you're unable to perform...

Not sure what you did wrong, but it works for me. See attached. Mynda