cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Re: How to roundup decimals and add comma in a chart data lable

@v-xida-msft @PowerAddict  Thank you for your replies, 

 

This is how it looks like in the SPlist, (Calculated Column)

Capture.PNG

 

Following is how it looks like in the collection, 

 

Capture1.PNG

 

This is the Formula I have used for the collection 

 

ClearCollect(LoanChartNew,ShowColumns('Loan Table',"Year","Title","Total_x0020_Outstanding"))

 

Hope this will help you to find a solution

 

Osmand

Highlighted
Community Support
Community Support

Re: How to roundup decimals and add comma in a chart data lable

Hi @OsmandFernando ,

Based on the needs that you mentioned, I think the Text function could achieve your needs. Please consider take a try with the following workaround:

Set the Items property of the Pie Chart control to following:

AddColumns(
           LoanChartNew,
           "TotalOutstandingValue",
           Text(Value(Total_x0020_Outstanding), "##,###") // LoanValueColumn represents the column you use to display the loan value, e.g. 900000.000.. within your Pie Chart
)

Then set the Series property of your Pie Chart control to following:

TotalOutstandingValue

 

In addition, you could consider modify your ClearCollect formula as below:

ClearCollect(
             LoanChartNew, 
             AddColumns(             
                        ShowColumns('Loan Table',"Year","Title","Total_x0020_Outstanding").
                        "TotalOutstandingValue",
                         Text(Value(Total_x0020_Outstanding), "##,###")
             )
)

then set the Items property of the Pie Chart control to following:

LoanChartNew

set the Series property of your Pie Chart control to following:

 

TotalOutstandingValue

 

Please take a try with above solution, check if the issue is solved.

 

Best 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

Highlighted
Post Prodigy
Post Prodigy

Re: How to roundup decimals and add comma in a chart data lable

@v-xida-msft Pie Chart Item property solution worked. But under the label I selected TotalOutstandingValue. Now looks perfect. 

 

Much Thankful

 

Osmand

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,217)