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


Report
All responses (
Answers (