Tag: Power BI

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

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

Super Charge Power BI: Power BI is Better When you Learn to Write DAX
Super Charge Power BI: Power BI is Better When you Learn to Write DAX
Ebooks

Data analysis expressions (DAX) is the data modelling language of Excel Power Pivot and Power BI. DAX language and DAX functions are the same in both Excel and Power BI and hence the knowledge is transferable between the two. The only difference is getting familiarised with the corresponding interfaces. This book is written to give you exactly that – hands-on practice. Inside you will find explanation of the concepts, sample… READ MORE

Data Virtualization in Microsoft Power BI – Part 2
Data Virtualization in Microsoft Power BI – Part 2
Blog Posts

In my previous post I showed how you can use Microsoft Power BI to create a Data Virtualization layer on top of multiple relational data sources querying them all at the same time through one common model. As I already mentioned in the post and what was also pointed out by Adam Saxton (b, t) in the comments… READ MORE

Data Virtualization in Microsoft Power BI
Data Virtualization in Microsoft Power BI
Blog Posts

Data Virtualization is actually a very new topic to me as I have barely seen it implemented in the real world or at any of my customers. But it becomes more and more interesting when working with big data where you cannot simply load all data into a single in-memory data model but still need… READ MORE