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
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
Hands on workshop walking attendees through integrating PowerApps and Power BI to create a scoreboard application. A video of these steps can be seen at: https://www.youtube.com/mspowerplatform Step 1. Create an app workspace to host the application. To do this: Log in to PowerBI.com and click on Workspaces > New Workspace. For people doing this at… READ MORE
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
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
