How to filter a table on click of Card in Power BI

Hello everyone and welcome to my blog. In today’s blog I will discuss the issue with Card visualizations in Power BI.

Card visualizations are great. They allow you to highlight the single most important pieces of information in a report and it look’s great too. However there is a small issue with the cards. As of the time of writing this blog, Power BI Cards are not clickable.

Let’s see the problem with that limitation. In the below video you can see that I am able to cross filter visualizations when i click the Pie slice or a record in the table, but when I click on the card, I am not able to cross filter other visualizations/ reports.

If you are thinking, I have a way to cross filter on click of Card visualization, well I haven’t got any. However we can create a PIE chartn with the same look and feel and functionality. So let’s get started.

Let’s get started with the PIE chart. Select the column you want to show the aggregated data in the Details section. Make sure to use the same column in Values and Details area.

Since I want to show the count of machines with black color, I have used the Color column in both the Details and Value area.

The next thing is to Apply the filter to make sure it consider machines with only Black color.

That’s great. We now have the data. But how to get the same look and feel? The first thing is to set the Report title. To do this, navigate to Format Visual tab.

Modify the Title text and it’s other properties as needed.

Set the Effects property to set the background color of the tile as needed.

Next set the following properties.

1. Set Legend to Off
2. Set Title to Off
3. The Slices color, set it to the same color you used for Effects properties.

The final step is to modify the Details label. Set it as per the screenshot below.

All set and done. Now your pie chart look like below. The one on the left is an actual Card. And the one on the right is the PIE chart.

And below is the behavior in action.

Hope you liked this post. If this post has helped, you can buy me a coffee.

For similar topics on Microsoft.NET and Power Platform, subscribe to my blog using the Subscribe option on right pane.

You will also like the below posts.

Debajit Dutta
Business Solutions MVP