Hide column when total equals 100%

Hello,

I am working on a diagramm that shows the percentage of open and closed issues in a project (Open Issues / Issues closed) in columns.
For better overall readability, how can I hide a column when the total of issues closed equals 100%?

TIA and best regards

Answer: Use the filter function on the Open Issues measure.

Click on “Open Issues” → “Filter Rows” → “>” (bigger than)

And set to filter values bigger than 0:

Once this filter is set up, issues that are no longer in Open status, will not show up in your report.
As soon as there is a new open issue, your report/dashboard will show this member again.

2 Likes