How can I only show greater than zero values column in column chart.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Here is a problem which I am facing. Kindly refer image.

As you can see in my column chart if ticket count is zero for SBU still it is visible in chart. I want to show only those SBU whoes ticket count is greater than 0. below is my code for chart Item property.

"If(
SBUSeletion = "All",
Filter(
CountOfSBU,
Or(
SBU = "Europe SBU",
SBU = "Global FS SBU",
SBU = "Cloud Infrastructure Services (CIS)",
SBU = "Americas & APAC SBU:(North America)",
SBU = "Americas & APAC SBU:(LATAM)",
SBU = "Americas & APAC SBU:(APAC Platform)",
SBU = "Corporate Common and Other (Group IT)",
SBU = "Engineering Services (DEMS)"
)
),
Filter(
CountOfSBU,
SBU = SBUSeletion
)
)"

CountOfSBU is my collection which has SBU and their ticket counts. how can edit my code or some other solution so that only more than 0 tickets count should be visible in chart.

Suggest some solutions.

Thanks in Advance!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try to filter the collection based on TicketsCount column values greater than 0 ...smthg like:
If( SBUSeletion = "All", Filter( CountOfSBU, TicketsCount>0 ), Filter( CountOfSBU, SBU = SBUSeletion ) )
Hope it helps !
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks It helped. Thanks alot.🙂