Press "Enter" to skip to content

Category: Power BI

Paste a List of Values into a Power BI Slicer

Dan English doesn’t want to click over and over:

Have you ever wanted to take a list of values from say an Excel spreadsheet and paste those into a Power BI slicer to filter the list? Like say you are only interested in particular set of items, but the list of items is long and filtering through a list of say a thousands values can take a while. I bet you have and this has been an item that has been requested for a very long time going back to 2017!

Well believe it or not, I just found out this week during a meeting with the product team it has been released!! 

Click through for the limitations, as well as a demo of how it works.

Leave a Comment

Power BI Accessibility Checklist

Elena Drakulevska has a checklist for us:

Whether you’re designing for executives using tablets, keyboard-only users, or screen reader tech, accessibility is not a nice-to-have. It’s a design standard.

Here’s the accessibility checklist I use in client projects and workshops—and now it’s yours too!

Click through for some good advice on how to make your Power BI dashboards and reports easy to use.

For another take on the topic, I recommend reviewing Meagan Longoria’s checklist as well.

Leave a Comment

A Peek at Fabric Translytical Task Flows

Teo Lachev writes a review about writing back:

The May release of Power BI Desktop includes a new feature called Translytical Task Flows which aims to augment Power BI reports with rudimentary writeback capabilities, such as to make corrections to data behind a report. Previously, one way to accomplish this was to integrate the report with Power Apps as I demonstrated a while back here. My claim to fame was that Microsoft liked this demo so much that it was running for years on big monitors in the local Microsoft office!

Are translytical flows a better way to implement report writeback? I followed the steps to test this feature and here are my thoughts.

Read on for Teo’s thoughts.

Leave a Comment

“Can’t Determine Relationships between the Fields” in Power BI

Marco Russo and Alberto Ferrari explain an error:

When you create a Power BI matrix, you drag and drop columns in the matrix, then add some measures, and Power BI figures out on its own which combinations of values to show. The process is so intuitive that we mostly ignore the details. However, Power BI sometimes cannot figure out how to populate the matrix, thus producing the error: “can’t determine relationship between the fields”. Adding a measure fixes the problem, but why? In some other scenarios, Power BI shows many empty rows, eliminating many of them only when you add a measure. Power BI shows a subset of the values in other scenarios, even when no measure is involved.

Read on for the explanation.

Leave a Comment

Methods to Expand a Power BI Matrix Visual

Chris Webb runs some performance tests:

If you have a Power BI report with a matrix visual on it it’s quite likely that you’ll want all the levels in the matrix to be fully expanded by default. But did you know that the way you expand all the levels could have performance implications, especially if you’re using DirectQuery mode? Here’s an example.

Click through to see what options are available to you and their performance implications.

Leave a Comment

Aesthetics and Usability as Complements

Elena Drakulevska explains that you can’t succeed without both:

There’s this UX law called the Aesthetic-Usability Effect. And it basically says:

People will lean more toward better-looking products—even if they’re not the best-performing ones.

Sounds wild, right? But it’s true. A gorgeous report might win hearts even if a more useful, but less attractive one, is sitting in the corner gathering dust.

And honestly? I agree… to a point.

Read on to see when it falls apart and why you can’t focus solely on one or the other. Utility curves are convex, after all.

Leave a Comment

Customizing Parameter Display in Power BI Paginated Reports

Andy Brownsword doesn’t like having parameters all helter-skelter:

Parameters in Paginated reports allow for us to tailor report contents based on user selected criteria. These were inherited from Reporting Services as a precursor to the slicers and filters in Power BI reports.

Coming from a Reporting Services background I have a soft spot for pre-defined paginated reports. However these parameters can sometimes get a little unruly. Here we’ll see what that looks like and how we can go about resolving the issue.

Click through to see what this means, as well as how you can fix it. Or embrace the chaos, your choice.

Leave a Comment

Rounded Corners in Power BI

Elena Drakulevska breaks out the sandpaper:

I’ve been seeing all kinds of shapes in Power BI reports lately—and seems like there’s a lot of guesswork when it comes to rounded corners. Some people just throw in a number because it “feels modern”, others skip it altogether. But rounding shouldn’t be random.

Wondering what to do with your edges? Putting in a radius just because? Or maybe your designs still feel… too pointy?

Click through for some thoughts on rounding corners in Power BI, as well as how to do it.

Leave a Comment

An Overview of the Power BI Ecosystem

Kurt Buhler looks at tools:

In general, the process to build and manage both models and reports in Power BI can be simplified to a few sequential steps that describe the “lifecycle” of this content. You can see this depicted below, as well as some examples of the various tools that you might use to support each of these steps. Shameless plug, Bravo, Vertipaq Analyzer, and Analyze in Excel were created by SQLBI, and SQLBI is involved in the development of DAX Studio, DAX Optimizer, and Tabular Editor.

Click through for an interesting table showing what fits where. If all you’re using is Power BI Desktop, there’s a whole world of additional functionality you’re missing out on.

Leave a Comment

Adding Carousel Buttons in Power BI

Boniface Muchendu builds a carousel:

Power BI carousel buttons allow users to cycle through visuals, measures, or text within a single report space—making your dashboards more interactive and space-efficient. While Power BI doesn’t include a native carousel visual, this guide shows how to simulate the same functionality using button slicers and field parameters. We’ll walk through several practical use cases, including switching between KPIs, toggling dimensions, and displaying text content, all with built-in Power BI features.

Click through to see how they work. I’m not a big fan of doing this on a proper dashboard, given that any visuals you’ve hidden on the carousel are no longer glanceable, but it’s a neat aesthetic idea for highly interactive reports.

Leave a Comment