Omit Empty Date Cells from Power BI Visual Data

[nrjunk]

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!

[Anonymous · Accepted solution]

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.

[lbendlin]

Is that x axis column coming from your calendar table? How is your data model wired?

[nrjunk]

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!