Multi PCI Card help

[gomezc73]

Hi Experts,

   I need help to show more information in a chart.

   Let me explain.

   I have this chart with calculated data

Additional, i need show for the same periods these information:

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%

That information is not calculated it is taken from others files and is only to be showed to explain the context..

I tried to show it in other matrix, but in matrix i can't show the 'commission rate' like a fixed value (it need SUM/AVG,Max, etc)

I tried dowloading the "multi target KPI", but the information is showed with no format. (also it show a green icon to buy a license)

Now, I would like to show that information in diferent cards, by example:

Or show it in a matrix table, by example

Since this is a corporate report, I need to show this data as is. without calculations

Any need ideas will be appreciatte.

Regards

[mostho]

> Since this is a corporate report, I need to show this data as is. without calculations

Does this mean you have the values youre trying to show in a table? Why not use a table visual then?

[gomezc73]

Hi, Thank you for your early response.

I need show the information by period in horizontal mode, just below of the chart.

The better way is using a matrix but then the rate is required be summarized.. i need show it without calculations.

[mostho]

> i need show it without calculations.

I understood this already. how does your data look like?

[gomezc73]

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%

[mostho]

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?

[gomezc73]

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

[mostho · Accepted solution]

Well, then there must be something in your data model or connections in your visuals that you didnt specify yet.

As you can see on my screenshot (last post), it works for me. you can have a look at my pbix.

[gomezc73]

Ok Thank you.

I going to validate my data..