Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Frequent Visitor

Matrix visual hide values columns if we don't. have data.

Hi Team, 


created the matrix visual , one of the measure don't have data on future quarters , I want to hide those columns which we don't have data, can any one help me , how to do it. here is example visual marked one need to hide if we don't have any data.  i don't want to squeeze the columns if we don't have data, it need to be auto hide if we don't have data. 

Advanced Thanks for your great help 


Picture 1.png



Frequent Visitor

i have voted, but is there any other way we can do it 

Frequent Visitor

Thanks for your reply !


i hope Some DAX can able to do it, if any one know can you please help here 



You can surely hope for that, but it will be more productive if you go  the idea route.

Super User
Super User

i don't want to squeeze the columns if we don't have data, it need to be auto hide if we don't have data. 


Not currently possible . If this is important to you please consider voting for an existing idea or raising a new one at

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors