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
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
When your report has a bunch of slicers and charts that can also add filters to the page resetting back to no filters can be painful. So we need a quick way to reset slicers. This post walks through the steps of creating a bookmark and the using that bookmark to reset the page by… READ MORE
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
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
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
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
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 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
A few months ago my esteemed colleague Patrick LeBlanc published a great video showing how you could use Power Automate (formerly known as Microsoft Flow) to send an email when a Power BI alert is triggered. This post is going to cover almost the same ground, except that I’m going to show you how to send an… READ MORE
