Unanswered

Issue with Pie chart

(1) Share

Report

Posted on by AntoineOA

Hello,

I am facing a problem with a pie chart. I build this screen one year ago and it was working perfectly until yesterday. I didn't touch anything but the pie is not showing. Here is the visual I'm suppose to have on left and what I have now on right:

The code I am using is this one : 

SortByColumns(
 AddColumns(
 GroupBy(
 Filter(
 CRA_CRA,
 UserId = _userDomain And InputDate >= _startDateAnalytics And InputDate <= _endDateAnalytics And Not ("XX" in ThisRecord.WBS)
 ),
 "WBS",
 "TypeGroup"
 ),
 "Total Work",
 Sum(
 TypeGroup,
 Work
 )
 ),
 "Total Work",
 SortOrder.Descending
)

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

KeithAtherton 3,705 Most Valuable Professional on at

Like (0)

Report
Hi @AntoineOA,

A few things to check:

If you resize or re-position the pie chart control, does it show? (In case it is currently minimized.)

Does the pie chart control have Visible property set to true?

If you select your code in the formula bar, can you see a table of results?

If you recreate the pie chart control and use the same data source, does it show?

If you recreate the pie chart control and use a different data source, does it show?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
AntoineOA 34 on at

Like (1)

Report
Hi @KeithAtherton ,

I tried to re-position the pie chart and nothing happened.
I do have visible property. It's the first thing I checked here. It's on true but it's still invisible.
I do no have a table of result. I only see it when I reduce the code to this :

Filter( CRA_CRA, UserId = _userDomain And InputDate >= _startDateAnalytics And InputDate <= _endDateAnalytics And Not ("XX" in ThisRecord.WBS) )

If I create a pie chart, the PieChartSample works. But my code was working nicely during months so it's strange that nothing showing here.
Yes it's working with an other data source. The code is the problem but I don't know why.

Was this reply helpful? Yes No
KeithAtherton 3,705 Most Valuable Professional on at

Like (0)

Report

Checking those helps narrow down the issue.

The image of the original, working pie chart shows values for "Total Work" but the new, not-working pie chart has blank values for "Total Work". I suspect "Total Work" is used in the pie chart and having blank values means nothing can be displayed.

Seeing as "Total Work" is a sum of CRA_CRA.Work, can you see values existing for the date range you're using?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
Verified answer

AntoineOA 34 on at

Like (1)

Report

Hello @KeithAtherton , I found the solution by adding ThisRecord before Work in the sum function. Thank you for you help! 😄

Was this reply helpful? Yes No
KeithAtherton 3,705 Most Valuable Professional on at

Like (1)

Report

Great news, well done! Thanks for the update.

Was this reply helpful? Yes No