Currency conversion applied to BI reports can include many different scenarios. Data in multiple currencies, report with a single currency Data in multiple currencies, report with multiple currencies Data in a single currency, report with multiple currencies The rule of thumb is to apply the currency exchange conversion upfront. Therefore, it is a good idea… READ MORE
In late January, Microsoft published the Power Platform: 2020 release wave 1 plan which lists all the new features that are targeting a release date before the end of 2020. The Power Platform ecosystem currently includes several different products that work reasonably well together and enable “users and organizations to analyze, act, and automate on the data to… READ MORE
Hands on workshop walking attendees through integrating PowerApps and Power BI to create a scoreboard application. A video of these steps can be seen at: https://www.youtube.com/mspowerplatform Step 1. Create an app workspace to host the application. To do this: Log in to PowerBI.com and click on Workspaces > New Workspace. For people doing this at… READ MORE
A not-so-well-known feature of the multi-row card visual in Power BI is that it can have its own title, called Card Title, in addition to the title any visual can have. In the image above, the Card Title is blue, and it is formatted separately from the visual title. It only works if you use one measure… READ MORE
Posting for my demos at the 2019 Virtual summit The first demo i went through was here: https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Integrating-PowerApps-Power-BI-and-Flow… The second walk through below: PowerApps is the perfect compliment to Power BI in that it makes it very easy to update or add data to the underlying datasets that Power BI is Visualizing. This walk through… READ MORE
When your report has a bunch of slicers and charts that can also add filters to the page resetting back to no filters can be painful. So we need a quick way to reset slicers. This post walks through the steps of creating a bookmark and the using that bookmark to reset the page by… READ MORE
Data analysis expressions (DAX) is the data modelling language of Excel Power Pivot and Power BI. DAX language and DAX functions are the same in both Excel and Power BI and hence the knowledge is transferable between the two. The only difference is getting familiarised with the corresponding interfaces. This book is written to give you exactly that – hands-on practice. Inside you will find explanation of the concepts, sample… READ MORE
A few months ago my esteemed colleague Patrick LeBlanc published a great video showing how you could use Power Automate (formerly known as Microsoft Flow) to send an email when a Power BI alert is triggered. This post is going to cover almost the same ground, except that I’m going to show you how to send an… READ MORE
Heather and John discuss webcasts, Power BI and using Tygraph for tracking Twitter tags Video Transcript Okay you have got me back-to-back folks here on day four of ESPC 19 and I am here with the lovely John Patrick White. Wow I got a musical introduction. Totally got a music introduction well I was singing… READ MORE
We have been waiting for this for soooo long! I’m very happy to announce the availability of the Power BI report web part for SharePoint Online! The new web part Microsoft is releasing today enables SharePoint authors to embed Power BI reports directly in SharePoint Online pages with no code required! In the sample below I… READ MORE
