Category: Power BI

Currency Conversion in Power BI Reports
Currency Conversion in Power BI Reports
Blog Posts

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

Creating a Send-smile-component for Power Apps using Power BI and Application Insights
Creating a Send-smile-component for Power Apps using Power BI and Application Insights
Blog Posts

Early February we released an exciting new feature that enables you to add telemetry logging to your application using Application Insights. That blog post can be found here: https://powerapps.microsoft.com/en-us/blog/log-telemetry-for-your-apps-using-azure-application-insights/ This blog post is a walk through for getting that running specifically for creating a send a smile experience from your Power Apps. You can also find… READ MORE

Power BI Security
Power BI Security
Blog Posts

A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the various “layers” of security. The Power BI service architecture is based on two clusters – the Web Front End (WFE) cluster and the Back-End cluster. The WFE cluster… READ MORE

New Features Coming to Power BI in 2020
New Features Coming to Power BI in 2020
Blog Posts

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

Applied Microsoft Power BI- Introducing Power BI
Applied Microsoft Power BI- Introducing Power BI
Ebooks

This book introduces information workers, data analysts, IT pros, and developers to Microsoft Power BI — a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone. Access Chapter 1: Introducing Power BI here. Book contents: Get insights from popular cloud services on any device! Implement sophisticated personal BI models! Enable team… READ MORE

Power BI – Dynamic Axis
Power BI – Dynamic Axis
Blog Posts

A question I come across in Power BI from time to time is how to configure a report to show an end-user a list of options, and then have visuals in the report use the selected item on the axis. There are a few ways this can get solved, such as using bookmarks. For this… READ MORE

Power BI – Introducing the Hierarchy Slicer
Power BI – Introducing the Hierarchy Slicer
Blog Posts

Does your data include a hierarchy? We often can end up with multiple slicers to walk the hierarchy taking up valuable screen. This post does a quick walk through using the new hierarchy slicer. Slicer Series This series will cover different topics regarding slicers. Slicers Introduction Resetting Slicers with a Bookmark Button Cascading Slicers Hierarchy… READ MORE

Using Text Measures in Multi-row Cards in Power BI
Using Text Measures in Multi-row Cards in Power BI
Blog Posts

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