Solved: Filter out empty columns in stacked column chart

Anonymous · ‎04-16-2020

I have a stacked colum chart, with a relative slicer showing the last 15 days of data:

I would like to filter out the days with no data, so I only see days with non-zero column height, but I am not seeing how to do that.

BA_Pete · ‎04-16-2020

Hi @Anonymous

Try going to Format>X Axis and change 'Continuous' to 'Categorical'.

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

BA_Pete · ‎04-16-2020

Hi @Anonymous

Try going to Format>X Axis and change 'Continuous' to 'Categorical'.

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Filter out empty columns in stacked column chart