Last seen: Jun 14, 2025
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 ...
Hi Peter, Strictly speaking you are correct however, most people incorrectly think a distinct list is a unique list, so I have maintained that vern...
Thanks, Peter. I should have got you to tech check the file rather than the person who I got to do it!
Oops, good catch. Thanks for letting me know. Fixed now.