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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (74,601)