Rename null pie items

(2) Share

Report

Posted on by Coopedup

355

Hi,

I'm adding some very simple charts/pies etc. And something that is a real pain is where a grouped field has a null value and means the pie display is "Items(2)" and I'd rather show "Blank". Is there a easy way to manage this?

AddColumns(GroupBy(AddColumns('Risk Trial - PowerApp', "TowerList", 'Impacted Tower rpt'), "TowerList", "GroupData"), "CountByTower", CountRows(GroupData))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Coopedup

In the record with blank, make the column that turns into the Series label, explicitly have the string "Blank" as in the below example:

Other than this, we do not know another way which would not result in the same thing you are seeing. You can see non-working examples attempted below:

NON WORKING EXAMPLES:

Blank Series Label:

Blank Record entirely:

Interestingly, a blank value for something that is not the series label, may still work for your use case (however it is not recommended because it shows the series label only correctly, but nothing in the chart - but if it is what you want, it can be done this way)- - for example:

In case someone else in this forum knows about another interesting way, please share it, but this is only way we know of right now.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!
@Coopedup

Sure thing...change your Items Property to the following formula:

AddColumns( GroupBy( AddColumns('Risk Trial - PowerApp', "TowerList", Coalesce('Impacted Tower rpt', "Blank")), "TowerList", "GroupData" ), "CountByTower", CountRows(GroupData) )

I hope this is helpful for you.

Was this reply helpful? Yes No
Coopedup 355 on at

Like
a
(1)

Report
Copy link

Link copied!

That is ace....I'd seen the Coalesce but really couldn't figure out where to place it. Excellent help!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Coopedup

Yes...Coalesce is a HIGHLY valuable function. I don't go a day without it! Personally, I just don't like the redundancy of things like If(IsBlank(something), "somethingElse", something) - so much clearer as Coalesce(something, "somethingElse") 🙂

Was this reply helpful? Yes No