Forum

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...

Hi Ndalowa, Please see the file attached. Note: you may want to consider fixing the vertical axis so they're all the same using a ghost series. ...

Hi Melissa, I doubt you can collate your data in a tabular layout from the get go, as it probably comes from a survey system that puts it in this f...

The image attached is actually 3 separate charts. You cannot have one chart with the vertical axis restarting at zero part way up. If you want them in...