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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous97
Frequent Visitor

Hide columns/rows in matrix if no data

Hello All,

 

I have requirement where we should not show the empty columns if no data available. Below is my requirement

In matrix visualization

Rows field- Id 

Column- time series

Values -measure 1 and measure 2

Based on timeseries if measure 1 column is empty then we should hide entire timeseries column (marked in yellow) 

IMG_20221206_164829.jpg

even though we have values in measure 2 column.

Please find the below screeshot.

Unfortunately i cannot share the sample file.

 

Any help appreciated.

Thanks in advance

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Anonymous97 ,

Sorry, but if there is no data, the column still exists in the table/matrix.

Power BI may not support this feature for now, hopefully Power Bi will implement this in the near future.

If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback.

Microsoft Idea (powerbi.com)

OR:

You can define the size of the column so you can hide then until is invisible just drag the border of the column, be aware that you may need to turn off text wrap on the options on column headers.

vyangliumsft_0-1670378372460.png

vyangliumsft_1-1670378423037.png

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @Anonymous97 ,

Sorry, but if there is no data, the column still exists in the table/matrix.

Power BI may not support this feature for now, hopefully Power Bi will implement this in the near future.

If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback.

Microsoft Idea (powerbi.com)

OR:

You can define the size of the column so you can hide then until is invisible just drag the border of the column, be aware that you may need to turn off text wrap on the options on column headers.

vyangliumsft_0-1670378372460.png

vyangliumsft_1-1670378423037.png

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Note this hiding answer doesn't work.
Both with tables and matrix, if you hide column when it doesn't have a value (or when it has a value), it doesn't appear back when it has a value. These graphs can only hide empty rows and not empty columns (besides the header).

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors