How to correctly transform data to show evolution with Radar Chart

[Anonymous]

Hello!

I need some help to solve this problem with the Radar Chart in PBI.

What I want to achieve is to report the evolution by year of  the average Sophistication level of my table just like this chart:

I have to regroup my data by Domain.

Without reporting the evolution there is no problem the problem is when I want to report the evolution by year.

Radar Chart without evolution by year: 

My problems is that I didn't figure how I can format my data to achieve this.

Here is my dataset:

Any help would be really appreciated 🙂

Thank you!

[v-deddai1-msft]

Hi @Anonymous ,

I'm not understand your reuqirement. And would you please supply data as text/file/table rather than a picture? Please try to explain more about your issue and you can refer to https://community.powerbi.com/t5/Desktop/radar-chart-filtered-comparison/td-p/591566 to see if it can help.

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

Best Regards,

Dedmon Dai