Category: Power BI

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

Updating the PowerBI Control inside a PowerApps Application
Updating the PowerBI Control inside a PowerApps Application
Blog Posts

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

Power BI MVP Book: A Book of Tricks and Techniques
Power BI MVP Book: A Book of Tricks and Techniques
Ebooks

This Power BI MVP book is not like a normal book used to learn Power BI. This book is a selection of articles from 21 Power BI MVPs from all around the world. Each chapter focuses on a particular subject. Featured topics include: AI, architecture, data modeling, data preparation, DAX and more. Download Chatper 24:… READ MORE

Dax KEEPFILTERS
Dax KEEPFILTERS
Blog Posts

If you ever spend time looking at DAX generated by the Power BI Desktop Performance Analyser, you may notice a function called KEEPFILTERS appear from time to time. It’s not a function I find myself using often, so I thought I’d do a bit of digging to find out what it does and when it might be… READ MORE

Power BI – Slicer Introduction
Power BI – Slicer Introduction
Blog Posts

Slicer Series This series will cover different topics regarding slicers. Slicers Introduction Resetting Slicers with a Bookmark Button Cascading Slicers Hierarchy Slicer Syncing Slicers Power BI reports can be made more flexible using simple slicers to allow your report consumers to slice and dice the data down to what they are interested in. This post… READ MORE

Overriding Slicers
Overriding Slicers
Blog Posts

A question I’ve received a couple of times recently is how to override slicer selections in Power BI visuals. Or more specifically, if the user selects a specific item in a slicer (or filter), how can I show data for other items a visual that may be related by my selection. An example of this… READ MORE