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 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. Read more…
PowerApp applications are a blank canvas that can be used to accommodate almost any business use case. Featuring deep integration into the rest of the Office 365 suite and the Power Platform, PowerApps are a great tool in the intelligent Read more…
Along with the free license, Power BI offers a couple of different licensing options. The main license types to worry about are called Premium and Pro. Which license you need largely depends on the audience that you need to present Read more…
For many entry level Power BI developers, using the built in date table in Power BI will work fine. Behind the scenes Power BI auto creates a date table based on the date values in your data. However, many experienced Read more…
Bookmarks in Power BI are a great way to create powerful reports and have a little more control over how the user interacts with your report. Essentially, creating a bookmark captures the Power BI report in exactly the configuration and Read more…
Fighting Over the Excel Filter A new feature that we’ve started to heavily use here at Kumo Partners is the Sheet View feature in Excel. This appeared to us at the perfect time as we utilize excel files embedded in Read more…
Power BI releases new updates frequently, and sometimes those updates are only available as a preview feature. In other words, the feature is not ready for complete release but it will work in most situations. This blog post will detail Read more…
At first glance the Table and Matrix visualizations in Power BI look similar. Both display data in a table format that reminds the user of Excel. However, understanding the difference between the Table and Matrix visualizations in Power BI is Read more…
Power BI’s existing data refresh schedules are limited and remembering to manually trigger a Power BI refresh can be difficult. One of the benefits of Power BI is receiving real time data, and Microsoft took steps to enhance this benefit Read more…