Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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 🙂
Solved! Go to Solution.
It has been resolved, Thanks for all the replies 🙂
It has been resolved, Thanks for all the replies 🙂
What ended up being the solution for this?
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?
Hi @mahenkj2 , Thanks for the reply
Please find the more detailed information below
sample data
When applied visual level filter we got this error
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.
@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.
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
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.