Tag: Power BI

Power Pivot and Power BI
Power Pivot and Power BI
Ebooks

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Download 2 Chapters: 8 – CALCULATE() –… READ MORE

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

Currency conversion applied to reporting 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 to… 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

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

Power BI – Cascading Slicers
Power BI – Cascading Slicers
Blog Posts

In this post I will look at filtering one slicer based a selection in another slicer. June 2019 Power BI Update included an update to allow a slicer to be filtered based on a measure, which means that you no longer need to use bi-directional relationships. Slicer Series This series will cover different topics regarding… READ MORE