Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Blank value causing PowerApps chart to go flat

(0) ShareShare
ReportReport
Posted on by 35

I have a PowerApp that uses a chart control to display data from an approval process.  Users can skip a step if the request was not made in the approval process. This causes a blank value in the data source, and also in the app.  If all steps completed and thus a time related to each step, the chart looks like this..

 

Tymlss_0-1717716070492.png

 

If a step is skipped, the entire chart goes flat.  I assume this is because the value "0" is given to that blank space, which in ticks would equate to over a hundred years ago, and thus relatively would make all other bars about the same time, or number of ticks away from the lowest value in the series.

Tymlss_1-1717716288165.png

As you can see above, the "Consult Time" has a blank value.  I have tried filtering the blank value in the items property of the chart, and it works, for example "Filter(variable, 'Consult Time' = Blank( ))".  Though it also removed the entire series of bars that were related to that piece of equipment's approval history.  

 

My next attempt will likely be to set a default value to the data source time columns, but if I do this too far from the actual "Shutdown Time", it will make the chart look less than ideal.  Is there a way to set the blank value to the lowest value in the series? 

 

What would be most ideal is allowing the blank column to show while also preserving the correct staggered appearance of the bars around it.  Below is a look at the items property of the chart..

Tymlss_2-1717717172819.png

 

The original variable that populates the chart is set on the click of a transparent button in a gallery, which is the result of a GroupBy function in a previous screen.  The GroupBy function groups all of the equipment by the area of the facility that it is located.

 

Tymlss_3-1717717376242.png

 

Any help is greatly appreciated!

 

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard