Comparing composition on Power BI

[Anonymous]

Hi all,

I would like to compare the target and median actual pay composition. In my example, pay is comprised of two elements: equity and cash. Under the target scenario, the components are single data points, whereas, under the median scenario, these are measures I calculated in DAX. What's the best visual to compare the composition of pay between target and actual scenario? 

If Power BI Sunburst chart is a viable option, what would need to go under the 'groups' field and what under the 'value' field?

Thank you

Giac

[v-yetao1-msft]

Hi @Anonymous 

Has your problem been solved ?If no, please provide your sample and the result you want .

If it has been solved, provide your method for the problem then consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Ailsa Tao

[v-yetao1-msft]

Hi @Anonymous 

Could you provide a detailed data for our reference ? Or you can provide the results you want .

Best Regards

Community Support Team _ Ailsa Tao

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

[Anonymous]

Thank you for helping out. I will share a sample .pbix file and screenshot of expected result shortly