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..
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.
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..
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.
Any help is greatly appreciated!