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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PaulDenne
Frequent Visitor

Matrix and Zero Columns

Hi all 

 

I have looked at previous posts about hiding /filtering out Zero columns in a Matrix

 

they all seem to suggest having a measure and the applying a filter to that but my Matrix has approx 50 columns 

 

would I have to create a measure for every column? 

The Matrix at the moment just shows the 50 columns with a count for about 10 rows for our different bases like 

 

HUBINC1INC2INC3INC4INC....INC50Total
A1100002
B0100012
C0100113
Total1300127

 

thanks

4 REPLIES 4
PaulDenne
Frequent Visitor

just tested, makes table easier to read removing all the Zeros but does not hide column from view if all blank still, INC3 and INC4 would still show but the zero are blanks

 

hope was to hide the unused columns as depending on slider selection, could be 30 + not needed making the table very unnecessarily wide

Hi @PaulDenne 

 

The reason the values still show is because the measure is put into the table/matrix. 

 

A workaround is that you need to use disconnected table measure, which should allow use a table for the values and if there are no values then it should not display.

Calculation Groups with Disconnected Tables in Power BI/AAS - FourMoo | Power BI | Data Analytics





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

thanks will try to have a look at that later today

GilbertQ
Super User
Super User

WHat you could do is when you bring your data in, you could change the zero to null?

 

Null values are not shown by default in Power BI.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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