Forum

Hi Sunny, This is either a credentials or permission error with the SQL server you're trying to connect to. You need to speak to your IT administra...

Hi Marciano, The Path Table technique only works with files saved on your PC or a local server. The file path in the image is a URL, which tells me...

Hi Robert, It appears to be caused by a change in 365. The file used to work and now with 365 it causes problems. There's a note under the video wh...

Hi Sunny, When you use & you're concatenating and to concatenate the data type must be text. You cannot concatenate numbers. First change the d...

Hi Darren, Welcome to our forum. When you're plotting data from a PivotTable in a Pivot Chart, as you are, you can only plot what is stored in the ...

It sounds like a locale issue that can be fixed in Power Query as explained in this video:

Great to hear, Mattias! Hope you have a lovely weekend too 🙂

Hi Mattias, Thanks for providing the information to help me understand the issue. The axis/row/column labels should always come from your dimens...

Hi Mattias, It sounds like a problem with the relationship. Regarding this: "So for one hour, that will simply be the the raw_value_diff_kwh/...

Hi Justine, Welcome to our forum! I suspect what you're seeing is that the sorting is applied based on the RAND results, but in performing the s...

Hi Peter, You can use a disconnected Slicer to do this. See example file attached. Mynda

Hi Caio, Embedding dashboards in PowerPoint is tricky, as explained in this video. You could embed the dashboard in a web page using the Excel W...

Hi Linda, The Lines.ToText function requires the lines as a list argument first, then the line separator e.g. Lines.ToText(LineList, ";") You...

Hi Mattias, There's two ways you can do this, either in Power Query before loading to Power Pivot model, or with the USERELATIONSHIP function. See ...

Yes, please see this tutorial on Nested IF formulas. Have a go and write the formula yourself. If you get stuck, come back and share your attempt s...