Filter visual by day of week

[KM3033]

I have a visual on my Power BI dashboard that tracks the number of sales closed and lost each week. Since my report is only manually updated once a week (on Mondays), I only want Mondays to show up on the axis. But right now, it looks like this:

I want to get rid of these gaps between the bars. I tried to create a date table with a "Day of the Week" column, then created a relationship between the date table and my main table, and then added a filter to the graphic to only show Mondays, but the filter didn't alter the axis.

Is there some way to only show each Monday's data on the axis?

[Anonymous · Accepted solution]

Hi @KM3033,

Try changing the X-axis Type to Categorical instead of Continuous. It worked for me.

[KM3033]

Thanks, @Anonymous! That worked!