Enhance Pie Chart Legend

(0) Share

Report

Posted on by Tango

1,168

Hi,

I have a canvas app with a pie chart that returns records based on a Month/Year Combo Box. All working perfectly.

Labels aren't appearing in the pie and I would also like to add them to the legend. eg

(10) - Project Cancelled (8) - No Budget

(4) - Another Reason (2) - Yet another reason

I was thinking that it would be a Concatenate inside the Items of the legend but just not quite sure with the exact code.

The Items code is as follows

If(
 IsEmpty(ComboboxCanvas1.SelectedItems),

 AddColumns(
 GroupBy(
 Filter(
 Quotes,
 FinalStatus = 1
 ),
 "Reason",
 "Grouped"
 ),
 "LabelColumn",
 Concatenate(
 Reason,
 " - ",
 Text(CountRows(Grouped))
 ),"Count",
 CountRows(Grouped)

 ),
 AddColumns(
 GroupBy(
 Filter(
 Filter(
 Quotes,
 FinalStatus = 1
 ),
 Text(
 FinalisedDate,
 "[$-en-US]mmm-yy"
 ) = ComboboxCanvas1.Selected.MonthName
 ),
 "Reason",
 "Grouped"
 ),
 "Count",
 CountRows(Grouped)
 )
)

Thanks in advance

Todd

Categories:

Building Power Apps

I have the same question (0)