Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
What's the best way to achieve this kind of table in PBI?
I tried to use KPI Matrix but no suceed so mcuh.
I need the possibilty to adjust the hight of the row , be able to sort etc.
data sample
| Customer | Actunal | Target | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 | Month7 | Month8 | Month9 | Month10 | Month11 | Month12 |
| 2647539 | 1331 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 1562039 | 1290 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 6758832 | 1263 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 7440034 | 1218 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 2642739 | 1208 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 3144558 | 1202 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 30774901 | 1194 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 8658033 | 1194 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 24619101 | 1166 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 8658233 | 1160 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 30772201 | 1158 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 30768601 | 1149 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 7253970 | 1148 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 2642739 | 1148 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 37597001 | 1145 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 4401030 | 1141 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 30789401 | 1140 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 37597001 | 1136 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 30769001 | 1135 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 6773732 | 1132 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 3764655 | 1107 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 6756832 | 1105 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 2642739 | 1105 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 30793601 | 1104 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 5685231 | 1102 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
| 24653401 | 1101 | 1200 | 1331 | 1290 | 1263 | 1218 | 1208 | 1202 | 1194 | 1194 | 1166 | 1160 | 1194 | 1166 |
Hi @nirrobi
I understand you're trying to create dashboards that look like Stephen Few's design. I'm trying to achieve this myself too
But didn't find an option to create spark lines or bullet charts in matrixes.
Have you made any progress?
Would you mind share some of your achievements?
Thanks a lot!
i didnt continue with this process as not good solution found 😞
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |