Zebra BI Cards - Preparing data: Basic card
This is the second article in the series Preparing data for Zebra BI Cards visual. Here you will learn how to build a basic KPI card by using a single Excel table.
Preparing data article series
Learn how to use a single Excel table for creating a KPI card
💡 A tip before we start: always have your KPIs organized as a dimension, as opposed to standalone measures for every single KPI. This is one of the most important rules when creating a KPI dashboard with the Zebra BI Cards visual. If you organize KPIs as measures, you will not get the desired result. When adding the KPI dimension to the Cards report, a dedicated card for every single KPI will be generated within the same visual.
You can use the same PBIX example as Mark did in the video. Download it below.
Now, let’s create a basic card using a single Excel table.
Step 1: Prepare a table in Excel which contains all of your KPIs and values.
Step 2: Copy the table and paste it to Power BI by clicking on Enter Data. Paste the table and click on Load. Check your data in the Data tab.
Once the KPIs are added to the visual, a dedicated card for each KPI will appear in the same visual.
Each individual card can then be formatted, resized, reordered, inverted, and further enhanced using a wide variety of options.
You don’t always have the option of putting all KPIs in a single table. Find out how to prepare data for a slightly more advanced report using the Power Query or consolidate data using DAX with the SWITCH statement.