Forum

Hi Nate, I'm not following what you want to achieve. Please upload a mock up in Excel of your scenario that illustrates the issue and desired resul...

Well done! I wasn't sure if your dataset could contain future dates, or if it only contained dates up to the current period. If your dataset conta...

Hi Bax, Yes, and I've already used that technique to calculate the Date6WeeksAgo, so I'm going to let you figure out how to do it as practice. If y...

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