Histogram chart displaying zero value columns

[jmable]

I'm trying to create a histogram based on a subset of statuses. So I created a slice that only shows requests that have the "Appt Status" values shown but how do I not show all the other values in the chart? I was trying to figure out if I could create a Virtual Column and a subset of Appt Status values but I couldn't figure out how to get that to work. Any ideas? I tried to use the enhanced charting options which works but didn't allow you to click on the columns to drill into the data which is what I need as well.

Here are my chart settings:

[Suvrutt_Gurjar · Accepted solution]

Please try below.

Please create a virtual or physical column called say [ApptStatus_V] with an app formula expression of [ApptStatus]

Now please base your histogram chart on the column  [ApptStatus_V] rather than column [ApptStatus]

The above solution assumes that the column [ApptStatus] is a required column and does not have any blanks. 

if it is not a required column, then you could have a slice on the table with an expression something like 

ISNOTBLANK([ApptStatus_V]) and then base the histogram chart on this slice and of course the column as  [ApptStatus_V]