Forum Discussion

Helper V

2 years ago

Solved

Multi PCI Card help

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 period...

mostho
2 years ago
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.

Helper V

2 years ago

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.

Helper II

2 years ago

> i need show it without calculations.

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

Helper V

2 years ago

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
Helper II
2 years ago

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
  Helper V
  2 years ago
  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

Related content