Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😞
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |