How to remove blank columns from matrix visual in POWER BI Desktop Level??

[Kondla333]

Hello All,

We have created a Matrix visual based on day wise, month wise, year wise data.  But the issue is we are getting blank columns when we filter the data by day wise at visual level. How can we overcome it ?  Can one help me on this

What we tried is :

1. Applied visual level filter to display is not blank data - error is memory availablity issue.

Thanks in Advance 🙂

[Kondla333 · Accepted solution]

It has been resolved, Thanks for all the replies 🙂

[mahenkj2]

Pls share sample data, or sample file and current state of visual where you can show the exact problem.

You said, memory availability issue, what's that?

[Kondla333]

Hi @mahenkj2 , Thanks for the reply

Please find the more detailed information below

sample data

When applied visual level filter we got this error

[mahenkj2]

After seeing your data, would like to know whether data is correct and you dont want blank column to appear in the visual or the blank comumn itself is a problem and infact you should see some data there?

or on other words

The values shown in % looks to be a measure, so your question is why that is blank in some column or just hide those blank columns?

Anyway, you should post some sample data in a file, if possible. It will expedite solution of this problem.

[Kondla333]

@mahenkj2 yes the data is correct, i don't want to see the blank columns in visual.

The values shown in % looks to be a measure, so your question is why that is blank in some column or just hide those blank columns? - yes i need to hide those balnks.

[SergioSilvaPT]

Hi @Kondla333 ,

If the problem is what i think you have a simple solution.

You have something similar to this:

and you have this:

You have to click in one of the dimensions on columns for example Day, and untick the option "Show items with no data".

Here:

Regards,

Sérgio Silva

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

[Kondla333]

Hi @SergioSilvaPT , Thanks for you suggestion

I have checked now, it's already unticked...is there any other way?? Plz suggest it will be really great.