Answered

Doughnut chart

(0) Share

Report

Posted on by NurNina

375

Hye, I want to create a doughnut chart. When I try to create doughnut chart inside an entity, the chart isnt like what I want it to be. How do I create doughnut chart that look like this:

I want both the field in the same doughnut instead of having more than one doughnut chart.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

v-xida-msft on at

Like (0)

Report

Hi @NurNina ,

Could you please share a bit more about your scenario?

Do you want to create a Doughnut chart in your CDS Entity, and display it in your Model-Driven App?

Do you want to create a single Doughnut chart in your CDS Entity based on the fields, rather than multiple Doughnut charts based on the fields? Regarding the needs that you mentioned, I afraid that there is no way to achieve your needs in Charts part of a CDS Entity.

Currently, the Doughnut chart in Entity Charts part would be rendered as multiple Doughnut charts based on the category option you set for your Doughnut chart.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Regards,

Was this reply helpful? Yes No
NurNina 375 on at

Like (0)

Report

Hi @v-xida-msft

yes, I want to create a single doughnut chart. Based on the image i've provided, I want the chart to breakdown into the number of events and the events it participated. Is there any way to do that,or maybe using xrmtoolbox?

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @NurNina ,

Yeah, I agree with your thought. The XrmToolBox may be the possible solution. You could use the XrmToolBox to create Chart for your CDS Entity.

Regards,

Was this reply helpful? Yes No
NurNina 375 on at

Like (0)

Report

yeah but unfortunately I havent found the right way to edit the chart.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @NurNina ,

Have you installed the 'Advanced Chart Editor' plugin in your XrmToolBox?

You need to install the 'Advanced Chart Editor' plugin in your XrmToolBox, then you could load the Chart added in your Entity and edit the chart as below:

Please check and see if the following video resource could help in your scenario:

https://www.youtube.com/watch?v=WE-uVC7Cg1w

Regards,

Was this reply helpful? Yes No
NurNina 375 on at

Like (0)

Report

I have but I havent found any way to edit the doughnut chart.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @NurNina ,

Please check the following screneshot for more details:

You could edit your chart in above configuration screenshot easily.

Regards,

Was this reply helpful? Yes No
NurNina 375 on at

Like (0)

Report

@v-xida-msft may I ask how do I link between the two fields.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report

Hi @NurNina ,

Actually, the Data description part in the Chart Editor is organized using FetchXML Query. You need to use FetchXML Query to link the two fields:

Please check and see if the following article could help in your scenario:

https://www.youtube.com/watch?v=ORRAZmV27SA

More details about FetchXML Query in CDS, please check the following article:

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/use-fetchxml-construct-query

Regards,

Was this reply helpful? Yes No