cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShanayaK Member
Member

Hide the whole quarter in Matrix if no data

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

Capture1.JPG

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.

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Hide the whole quarter in Matrix if no data

Hi @ShanayaK ,

 

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

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)