Skip to main content




Let me show you how to create a card in Power BI with an example. The Power BI card is useful for displaying a single number (or metric value). For example, if we want to track total orders, total sales value, or total quotes we send, we can use this visualization from the Power BI card.

For this Power BI Card demo, we will use the SQL data source that we created in our previous article. So, check out the Connect Power BI to SQL Server article to understand the Power BI data source.

How to create a card in Power BI

Drag and drop the Sales Amount section of the fields onto the canvas to automatically create a column chart, as shown in the following screenshot.

create-a-card-in-power-bi-1-3609840<>create-a-card-in-power-bi-1-3609840

Click on the Card below the Display section. Automatically converts the column chart to a card. In the screenshot below, you can see the card showing the total sales amount.

create-a-card-in-power-bi-2-8637731

Create a card in Power BI focus 2

To create a Power BI card, first click on the Present Card in the Display section. You will create a Card with fictitious data, as shown in the following screenshot.

create-a-card-in-power-bi-3-3931217

Let me drag the English country region name (dimension data) to the Fields section. As you can see, it shows the name of the first country as the value of the card.

create-a-card-in-power-bi-4-1955560

You can change the First role to any other role that Power BI supports.

create-a-card-in-power-bi-5-1006660

Next, let me remove the country name and add the sales amount to the Fields section.

create-a-card-in-power-bi-6-2840905

By default, it uses the default aggregate function named SUM. But you can change this added function according to your business requirements.

create-a-card-in-power-bi-7-3967279

Let me quickly format this card.

NOTE: I suggest you refer to the Format Card article to understand the available formatting options.

create-a-card-in-power-bi-8-2299372