cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NurNina
Post Patron
Post Patron

Doughnut chart

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: 

dousghnut.JPG

 

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

1 ACCEPTED SOLUTION

Accepted Solutions

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:

1.JPG

 

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-quer...

 

Regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
v-xida-msft
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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? 

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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:

6.JPG

 

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

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

 

Regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Hi @NurNina ,

Please check the following screneshot for more details:

9.JPG

 

10.JPG

You could edit your chart in above configuration screenshot easily.

 

Regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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:

1.JPG

 

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-quer...

 

Regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,489)