Forum Discussion

gomezc73's avatar
gomezc73
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 periods these information:

   

PeriodCredit Card AmountCommision Rate
2023-09        4,646,675,075.8090.37%
2023-12        4,955,376,614.7092.94%
2024-03        5,739,061,781.5092.70%
2024-06        5,962,483,515.4091.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's avatar
    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.

8 Replies


  • > 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's avatar
      gomezc73
      Helper V

      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's avatar
        mostho
        Helper II

        > i need show it without calculations.

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