Forum Discussion
Multi PCI Card help
Hi, I simulated the data in excel to show how i need display the data in PowerBI.
If i can show in cards, it must be showed in this way:
If i can't show it in Cards, maybe i can show it in a matrix (something like this)
Or any other way to show the data will be appreciatte.
i have the data in a table
| Period | Credit Card Amount | Commision Rate |
| 2023-09 | 4,646,675,075.80 | 90.37% |
| 2023-12 | 4,955,376,614.70 | 92.94% |
| 2024-03 | 5,739,061,781.50 | 92.70% |
| 2024-06 | 5,962,483,515.40 | 91.97% |
I still dont get your issue. If you should take the values as they are (without calculation), then the records must be unique - one per period, right?
If so, where is the problem with sum in the matrix visual? the sum of a single value is the single value - you could also take min or max or whatever ...
If the records are not unique (per period) what should then be shown - without calculation?
Hi,
When i tried to show the data in a matrix, the 'commision rate' is required with SUM/AVG, etc.
If i select SUM, by example the the rate in the period is the same 2851.54 in the four periods