Before building a custom component with PowerApps Component Framework make sure that you have Node.js, Visual Studio Code (or another IDE), and the most recent version of the PowerApps CLI downloaded. If you are missing any of these items please refer to Part 1 of this blog series which walks Read more…
The PowerApps component framework (PCF) lets developers build re-usable code snippets called “Components” for model driven and canvas applications. The components can be used in multiple applications to enhance the user experience and drive a business use case. One of the examples I’ve run into is using the map functionality Read more…
External tooling is incredibly useful for extending capabilities in Power BI that might not be native to the application. As an example, the DAX editor in Power BI itself can be really cumbersome to develop larger DAX statements. DAX Studio negates this issue by giving you a dedicated environment to Read more…
Using a measures table in Power BI is generally considered best practice, and there are certain advantages to using one. However, I’ve found in my experience that the negatives outweigh the positives and that measure tables simply aren’t that intuitive. In Power BI, measure tables are used to contain all Read more…
Creating a map visualization in Power BI to display location data is not difficult. Power BI ships with a couple of different options available out of the box, and more can be added through the visuals store. Out of the box options include a native map, a “Filled Map” and Read more…
Figuring out the difference between fact and dimension tables in Power BI can be complicated. In this blog post we’ll go over the difference between the two and when they should be used. When you are building a data model fact and dimension tables are the two types of tables Read more…
A little while ago, a client came through with a list of 400 addresses that they wanted displayed in a map visual in Power BI based on specific criteria. Unfortunately, in order to display the addresses in the way that the client wanted the map visual required us to get Read more…
Canvas PowerApps Navigation As app makers create more complex PowerApps, the need to navigate a user across the various screens in the app becomes a necessity. A lot can be taken from the web design world in how we can provide this experience. Two common patterns that we can take Read more…
Variables in Power BI can be a very powerful way to enhance your DAX expressions and expand the possibilities of what DAX can do. Before Power BI supported variables, needing to use CALCULATE and the EARLIER function were cumbersome and created difficulties for data modelers. Today, those difficulties can be Read more…
The pagination options in Power BI are a great way to break your Power BI reports down into manageable bites. Adding more pages can give a designer more real estate to work with and more ways to break down data. On the flip side, too many pages makes the Pages Read more…