Filter a cluster column chart on multiple columns

[MrBacon]

Hello everyone,

I am trying to filter a cluster column chart to only show servers with less than 100% uptime.

The data source populates the table with servers as columns and months as the rows.

In the chart the X-axis is Month/Year, with Y-Axis being the different servers.

Example data:

Any help is appreciated.

[HotChilli · Accepted solution]

It's not going to be easy with the data in that format.

I think you should Unpivot all the columns except 'Month'. You'll have all the numeric uptime figures in one column and you can filter that from the filter pane on the clustered column chart 

[MrBacon]

 I spent hours trying to work that out and got nowhere. That solution fixed it in seconds.

Thank you so much.