Forum Discussion
Creating A KPI Dashboard - Grouping multiple data type displays
Hi Walt1010,
You're absolutely right. Aligning multiple KPI types (percentage, decimal, and text) in multiple table visuals is painful. Power BI wasn’t designed for pixel-perfect multi-table alignment. But there are clean alternatives that solve your issue without fighting the UI.
Instead of multiple table visuals, convert your KPIs into a normalized table and use a single matrix to keep alignment perfect.
Step1: Create a table that defines your KPI list
------DAX------
KPI List =
DATATABLE(
"KPI Name", STRING,
"KPI Type", STRING,
{
{"On-time Shipment %", "PERCENT"},
{"Avg Delivery Days", "DECIMAL"},
{"Supplier Status", "TEXT"},
...
}
)------DAX------
Step 2: Create a Universal KPI Measure
------DAX------
KPI Value =
SWITCH (
SELECTEDVALUE('KPI List'[KPI Type]),
"PERCENT", [KPI % Measure],
"DECIMAL", [KPI Decimal Measure],
"TEXT", [KPI Text Measure]
)------DAX------
Now you place KPI Name on rows and KPI Value on values,
All KPIs rendered in one clean, aligned visual with full styling control.
=====================================================
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Jaywant Thorat | MCT | Data Analytics Coach
Linkedin: https://www.linkedin.com/in/jaywantthorat/
Join #MissionPowerBIBharat = https://shorturl.at/5ViW9#MissionPowerBIBharat
LIVE with Jaywant Thorat from 15 Dec 2025
8 Days | 8 Sessions | 1 hr daily | 100% Free
Walt1010 , Not very clear. In case you want create slicer then Both Field Parameter and Calaucltion group can take care of group. In case you need grouping Calculation group can take care. You can all measure in that and have format
Or you can have simple item like
With format
IF (
SEARCH("%", SELECTEDMEASURENAME(),, 0) > 0,
"0.00%", // format for percentage
"#,0,.00 K" // format for values divided by 1000
)