Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

How to link between two charts?

Good afternoon

I have the following graph that I would like to take the data of the total sums of each month (data that is put together automatically but I do not calculate it): (data that says 167 million, 128 million, 112 million, and 79 million).

gcarrasco_2-1753203497264.png

With that data, I would like to have it in some form, as if to get the percentage in the other graph:

gcarrasco_3-1753203511425.png

I want each item (training, meetings, not charged, suspended, internal activities, rework) to be expressed as a percentage of the total values.

Training x 100% / maximum value of the corresponding month = %Percentage of training in that month.

I wouldn't want to have to calculate everything by hand. for each month.. It's a lot.. There should be an easy way. That is why I come to you, to see if you have any idea how to do it.

Thank you!.

Best regards.

1 ACCEPTED SOLUTION

It was fixed by adding a relationship between the tables with the MES column.

gcarrasco_0-1753887268247.png

Thank you!

Best regards.

View solution in original post

18 REPLIES 18
v-karpurapud
Community Support
Community Support

Hi @Syndicate_Admin 


Thank you for reaching out to the Microsoft Fabric community. 
 

We have implemented a combination of DAX measures and a relationship between the tables within the dataset. The logic enables comparison of Gastos vs Facturación by MES and calculates the percentage contribution of each No Facturable category relative to total monthly Gastos.

 

 

While the exact structure of your dataset is not fully known, a sample dataset and I’ve created a sample .pbix file to demonstrate one possible solution by creating a measure:

-----Measure-----

Porcentaje_NoFacturable = 
DIVIDE(
    SUM('NoFacturables'[Valor]),
    [GastosTotales_Mensuales],
    0
)

---- Another Measure-------

GastosTotales_Mensuales = 
SUM('Gastos'[Suma de Fate]) + 
SUM('Gastos'[Suma de Aluar]) + 
SUM('Gastos'[Deriv. madryn])


Please refer to the attached .pbix file for a working example and review the implementation.

I hope this information proves helpful. If not, please feel free to share additional details, and we’ll be happy to
assist you further.

Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.


Hello! How is it going?. I tried but unfortunately the calculation of the percentage is not good. It seems to me that he does not calculate the percentage month by month. I don't see your attachment.

April Training: 5,187,710

Total turnover April: 78,951,173

Training percentage: 6.75% and in the graph with the formulas you passed me, it gives me 1.61%

I attach the program: https://drive.google.com/file/d/1ovgSYpK6n6N6PHkV-5JuQZZpcOi6TXEy/view?usp=sharing

Hi @Syndicate_Admin 

Thank you for your response and for providing the details. It seems that there is a possible discrepancy in the percentage calculation and are prepared to review it further. We are unable to translate the file you sent. Could you please provide a translated version? This will allow us to better understand the data structure and support you more effectively.


Thank You.

Nice day. The file is in Spanish. What language do you want to translate it into?

There I separated the four graphics more clearly on a single screen:

1) Total billing graph (correct values: the sum of all the months gives $486,250,492)

2) Percentage of training that gives error.

3) Training Chart

4) Total billing per month (there you can see the error that the total shown is 323,081,275, that's why you miscalculate the percentage).


How could I correct it?

I attach the link to the file

https://drive.google.com/file/d/1VL8NpMeIeB-fx2JTxaUATOlyriNFroZE/view?usp=sharing

gcarrasco_0-1753794406824.png

Hi ,

The problem occurs because the total monthly Gastos used in the percentage calculation is incorrect it shows only a partial sum instead of the full monthly billing (Facturación). This causes the calculated percentages (such as for Training in April) to be much lower than they should be. Ensure that the [GastosTotales_Mensuales] measure accurately calculates the total Gastos for each month, not a sum over the entire dataset or an incorrectly filtered value. You can achieve this by applying the ALLEXCEPT() or KEEPFILTERS() function in the measure to maintain the month context. 

 

GastosTotales_Mensuales =

CALCULATE(

SUM('Gastos'[Valor]),

ALLEXCEPT('Gastos', 'Gastos'[Mes]))

 

With this, the percentage measure will correctly reflect the month-by-month values:

 

Porcentaje_NoFacturable =

DIVIDE(

  SUM('NoFacturables'[Valor]),

   [GastosTotales_Mensuales],

   0

)

 

Also, please translate the file into English to help us better understand the fields and logic and provide more accurate response.


Regards,
Karpurapu D.

It was fixed by adding a relationship between the tables with the MES column.

gcarrasco_0-1753887268247.png

Thank you!

Best regards.

Hi @Syndicate_Admin 

Thank you for providing the update. We are pleased to know that your issue has been resolved.

 

Good day, how are you?

I did what you say, and it's still the same.

Total turnover = calculate(sum('Invoicing, fixed expenses and wage bill'[Aluar])+sum('Invoicing, fixed expenses and wage bill'[Fate])+[Deriv. madryn], ALLEXCEPT('Invoicing, fixed expenses and wage bill','Invoicing, fixed expenses and wage bill'[MES]))
It seems to me that the problem is not there, but that the different tables do not synchronize with the MES column. Each table has its MES column and they are not related. I made a relationship with calenadario MES and the problem remains the same. The billing sum is not done correctly.
Ashish_Mathur
Super User
Super User

Hi,

From the second image i observed that you have dragged may items to the column labels.  Ideally that should not be the case.  Share some data to work with and show the expected result in a simple table format.  Once we get that correct, we can build any viz.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hello! How are you?. I attach the program: https://drive.google.com/file/d/1ovgSYpK6n6N6PHkV-5JuQZZpcOi6TXEy/view?usp=sharing

I look forward to advice.

thank you

Best regards.

There is absolutely nothing i can understand there with so many tabs/tables and a different language.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Nice day. The file is in Spanish. What language do you want to translate it into?

There I separated the four graphics more clearly on a single screen:

1) Total billing graph (correct values: the sum of all the months gives $486,250,492)

2) Percentage of training that gives error.

3) Training Chart

4) Total billing per month (there you can see the error that the total shown is 323,081,275, that's why you miscalculate the percentage).


How could I correct it?

I attach the link to the file

https://drive.google.com/file/d/1VL8NpMeIeB-fx2JTxaUATOlyriNFroZE/view?usp=sharing

gcarrasco_1-1753794709350.png

Hi,

There must be a date column in the Calendar table and a relationship from the Date column of your various Fact tables to the Date column of the Calendar table.  Do that and share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hello! It's as you say. There I was able to generate a relationship in the following way and it was good for me !.

gcarrasco_0-1753887176366.png

Thanks a lot!!!.

Best regards.

Hello! How is it going?.

There I made two relationships between the MES calendar table and the MES column of each table, and the problem remains the same.

gcarrasco_0-1753879948841.png

It seems to me that it is as you say, the MES column of each table is not unified. How is it done?

https://drive.google.com/file/d/1G4XHm66yQHUyuM_JNsaPzNnGtFGqu-D6/view?usp=sharing

Thank you

The language is Spanish and we are in a Spanish forum. I don't know what I expected. It seems to me that you don't want to contribute. Thank you. The same. Best regards.

Royel
Responsive Resident
Responsive Resident

Hi @Syndicate_Admin you want the percentage to be based on whatever is currently selected in your report, try this measure 

Dynamic Category Percentage = 
DIVIDE(
    SUM(YourTable[CategoryValue]),
    CALCULATE(
        SUM(YourTable[CategoryValue]),
        ALLSELECTED(YourTable[Category])
    )
) * 100

I hope this method will work. Let me know your progress. For this case, Its better if you create some sample data like 5-10 records and show case the table relationship and the explain what you want to achieve then its very easy for others to understand and solve the problem.


 
Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

Hello! No, I would like the percentage of each one (training, meetings, not charged, suspended, internal activities, rework) with respect to the total amount of billing in the same month.

April Training: 5,187,710

Total turnover April: 78,951,173

Training percentage: 6.75%

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.