Donut Chart not showing Correct Legend/Values Split

[julesdude]

Hi,

I have the following two tables:

Credit Rating table:

Tenant Reference	Rating Date	Credit Rating Source	Credit Rating
1000	22-Feb-23	SourceA	Low
1000	10-Oct-22	SourceA	High
1000	07-Jun-21	SourceA	High
1000	07-Jun-20	SourceA	Medium High
2000	10-Jan-23	SourceA	Low-Medium
2000	18-Oct-22	SourceA	Low-Medium
2000	16-Oct-21	SourceA	Low
2000	14-Nov-20	SourceA	Neglible
2000	01-Apr-19	SourceA	Neglible
2000	10-Apr-18	SourceA	High
3000	28-Feb-23	SourceA
3000	28-Feb-22	SourceA

Annual Net Rent table:

Tenant Reference	Lease Ref	Annual Net Rent
1000	1	10000
1000	2	10500
1000	3	11000
2000	10	20000
2000	11	20200
2000	12	20300
3000	30	40000

My dognut chart isn't displaying as it should. I need the Legend to show coloring by Credit Rating (Credit Rating Source only taking entries by SourceA) and segmented to show which portion of Credit Rating category for each tenant covers the  Annual Net Rent. I'm getting something like this (Ive whited out some values), but these figures are wrong:

[FreemanZ]

hi @julesdude 

Try to pull Annual Net Rent column to the legend of the Donut Chat and create a slicer with Credit Rating column. Is that the expectation?

[julesdude]

Hi @FreemanZ 

Yes I am doing the following:

However, the totals all exceed the total annual rent amount.

I am thinking is the problem maybe because for the credit rating table there can be many scores against the Tenant Reference. It would need to assign the tenant with the Annual Net Rent the latest credit rating score by date - soonest before the date picker in the report which is measure [as of date].