Ring chart issue

[Loulou]

Hello everyone, I am trying to copy a ring chart from excel on power BI. I imported my table on power and created my graph by applying filters and a macro. However, I get duplicates. For example, the category 'cancelled by supplier' should appear at 31.14% but it appears in dark blue at 29.94% and purple at 1.2%. I have a total of 3 duplicates of this type in purple in the category named blank (vide). I've done everything and I still can't solve this error.
Thanks for your help !

[Anonymous]

Hi @Loulou ,

If your expression is fine, check the relationship. This is usually a result of one-to-many relationships, as not knowing your specific data model, you can follow this linked tutorial to clear the blank:

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.