Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 😞
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |