Tag: Power BI

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

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