Forum

Hi Bax, You can create variables in your query that you can reference. See file attached. Mynda

Use Riny's solution if your data was loaded via Power Query. If not, in the Power Pivot window, you can click the top left corner of the table where t...

Hi Sirajus, That is a very small screen you're using! First, I would minimise the ribbon by double clicking on one of the ribbon tabs. You can s...

Interesting question, Danielle. This post answers it for you. Mynda

Hi Yen, It will depend on the structure of your model, but generally speaking, it would be like this: GrossMargin = Sales[SalesAmount] - Sales[T...

Hi Kevin, It looks like an update has added functionality that allows you to apply formats to all series in one go, or individual bars by selecting...

Hi Kevin, Can you please send me a screenshot of what you see under the Admin Portal (accessed via the cog icon) > Tenant Settings > Integrat...

Hi Kevin, I've replied to your emails regarding the workbooks and Power BI Service maps, but for others with similar issues, here is my reply: T...

Hi Amit, It looks like you've increased the font size in the Slicer values, probably because your canvas size is larger than the default making the...

Hi Sheela, The SharePoint connector is only available with a Microsoft 365 Apps for Enterprise license. Mynda

Nothing you can do to prevent that, Akash. Note: please don't email and post on the forum as this requires twice the work for you and me. The forum ...

Hi Dom, I'm not sure what you mean by 'creating your key'. However, if you want to input the status in a single cell, you could then use Power Q...

Hi Peter, The calculation in column H is me demonstrating the calculation that's taking place in the background of the Conditional Formatting rule....

Hi Peter, I can't provide the solution to this because I'm asking you to create a name and if I have already created that name, you'll get an error...

Hi Yen, Creating a Profit and Loss statement in Power BI/Power Pivot is very difficult because it's not designed to work on rows within columns. I ...