cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheRealFlori
Helper I
Helper I

Pie Chart Labels from Column

Hello together,

 

i have a Problem. I have a collection with 3 Columns. I would like to use the Columns as Labels.

So that i have a Part 1, a Part 2 and a Part 3 on my Pie Chart.

 

I have this Code in my Chart Items:

AddColumns(Test; "B"; DateDiff(Incident_Gallery.Selected.B_Start; Incident_Gallery.Selected.B_End; Minutes); "L"; DateDiff(Incident_Gallery.Selected.S_Start; Incident_Gallery.Selected.S_End; Minutes); "R"; DateDiff( Incident_Gallery.Selected.R_Start; Incident_Gallery.Selected.R_End; Minutes))

 

I need 2 more Labels:

Labels.png

It looks write now:

Chart.png

 

Do you have any hints any Tipps for me?

 

 

4 REPLIES 4
a-ovbord
Community Support
Community Support

Hi @TheRealFlori,

 

Can you try adding a GroupBy and Filter expression as explained in this thread here and see if that helps with your setup?

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-add-a-Pie-Chart/td-p/29772

 

Thank you,

Ovidiu

 

Hi @a-ovbord 

 

Thanks for your fast answer and sory for my late reply. 

 

I've tried your Idea. But for what should i Filter for? 1 Only have 1 Row of Values and want to show the 3 columns as a Pie Chart.

 

My Collection looks like:

 

ClearCollect(INC; 
             {Benachrichtigungszeit:DateDiff
			(
				Incident_Gallery.Selected.Benachrichtigungszeit_Anfang; Incident_Gallery.Selected.Benachrichtigungszeit_Ende; Minutes
			);
               Lösungszeit:DateDiff
			(
				Incident_Gallery.Selected.Störungsbehebung_Anfang; Incident_Gallery.Selected.Störungsbehebung_Ende; Minutes
			); 
               Rückkehrzeit:DateDiff
			(
				Incident_Gallery.Selected.Rückkehr_zu_Normalbedingungen_Anfang; Incident_Gallery.Selected.Rückkehr_zu_Normalbedingungen_Ende; Minutes
			)
         }
        )

 

 

My Collection looks like this:

2020-03-10 15_01_16-MIM Blog NEXT - Gespeichert (nicht veröffentlicht) - Power Apps.png

 

I've tried this as Items:

 

GroupBy(Filter(INC; ); "Benachrichtigungszeit"; "Lösungszeit"; "Rückkehrzeit")

 

 

i want a Pie Chart with 3 Parts B: 43; L 154; R 233

Like in Excel:

2020-03-11 08_43_53-Window.png

 

Thanks and Regards

Florian

Hi @TheRealFlori,

 

For the chart pie to work, you'll need at least 3 rows with values.

I have structured your data on 2 categories: Title and Value and added the data as rows.

This is how the collection looks like:

ClearCollect(INC, 
	  {Title: "Benachrichtigungszeit", Value: 43}, 
	  {Title: "Lösungszeit", Value: 154}, 
	  {Title: "Rückkehrzeit", Value: 233}	 
	)

 

image.png

Then inside the chart pie I have referenced the collection: INC
image.png

Would this be doable for your setup?

 

Thank you,

Ovidiu

Hi @a-ovbord 

 

thanks for your answer. This should be possible, but do you have Syntax for me?

I only get a collection with 3 Columns an one Row .... 2 Columns and 3 Rows i dont get this to work ...

ClearCollect(INC; 
             {Benachrichtigungszeit:DateDiff
			(
				Incident_Gallery.Selected.Benachrichtigungszeit_Anfang; Incident_Gallery.Selected.Benachrichtigungszeit_Ende; Minutes
			);
               Lösungszeit:DateDiff
			(
				Incident_Gallery.Selected.Störungsbehebung_Anfang; Incident_Gallery.Selected.Störungsbehebung_Ende; Minutes
			); 
               Rückkehrzeit:DateDiff
			(
				Incident_Gallery.Selected.Rückkehr_zu_Normalbedingungen_Anfang; Incident_Gallery.Selected.Rückkehr_zu_Normalbedingungen_Ende; Minutes
			)
         }
        )

 

Thanks and Regards

Flo

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,795)