Only show days with values in a chart

[rogerdea]

Hello

I have a visual where at weekends there is no data, which is correct.  I would like to remove any days where there's 0 records. (so in this visiual remove 10th & 11th July).   Occasionally there is overtime so it could be possible to have weekend values, so was thinking just removing weekends won't work.

How can i only show dates where there are > 0 records.  I tried filtering the data where number of records > 0 but it didnt work.  what would be the approach?

any ideas?

Roger

[rogerdea · Accepted solution]

Eventually figured out the easy way to fix this, on the X axis changing the type from Continuous to Categorical removed all the days with 0 values.

[BA_Pete]

Hi @rogerdea ,

Have you tried adding your chart measure as a visual-level filter and seting it to [yourMeasure] is greater than 0?

Pete

[rogerdea]

Yes i have tried filtering on records > 0 but it doesnt work.  I do have relative date filtering the past 14 days on the date axis, so could it be this forcing the 14 days regardless?  In which case i guess i will need to create a table with the 14 most recent values by date and use that as my axis.

[BA_Pete]

Hi @rogerdea ,

When you say you have tried filtering > 0 records, do you mean you are filtering this at the table level?

My suggestion was to specifically filter at the VISUAL level. Whatever measure you have in your chart that is producing the numbers for the columns, apply the filter directly to this measure from the filter pane.

Pete