Forum Discussion
Omit Empty Date Cells from Power BI Visual Data
Hello!
I am trying to omit my blank Excel cells from the below visual. I am using an Excel table to track quarterly asset changes using a date column. Here I'd like only to see the numbers for Q1-Q4. I've tried a couple of expressions but have gotten nowhere.
Any help is greatly appreciated. Thanks!
Hi nrjunk
You just need to do is remove the blank columns from the filter.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- lbendlin
Super User
Is that x axis column coming from your calendar table? How is your data model wired?
Hi lbendlin
Thank you for responding.
I did not build a calendar table for this. I am simply pulling the date data from a column in our Excel sheet. The x-axis is the date column by quarter and the y-axis is the count of our assets (rows).
It's a pretty simple setup and I thought I could use Dax to filter out the rows with no date input in that particular column.
Thank you again for all your help!
Hi nrjunk
You just need to do is remove the blank columns from the filter.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
