Hide the whole quarter in Matrix if no data

[Anonymous]

Hi All,

I have created a matrix where we are replacing all the Blank values with "*". I have created a DAX calculation, which is working fine. Field used in below Matrix are : 

Rows : City Name

Columns : Calendar Quarter

Values : Number of Orders Cancelled

Now the issue if , if we have all blanks in that quarter, we want to hide that quarter in the Matrix. 

Please advise how can we resolve this.

Thanks.

[v-frfei-msft]

Hi @Anonymous ,

There is no such an visibility option that supports to conditionally hide/show column in Matrix. One option is to hide or show the values in the column by creating measures, but column headers are still appeared even there is no data. Reference: https://community.powerbi.com/t5/Desktop/How-can-i-hide-Column/td-p/110087