Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
KM3033
Frequent Visitor

Filter visual by day of week

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:

 

Forum weekly progress.png

 

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.

 

Forum day of week filter.png

 

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @KM3033,

 

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @KM3033,

 

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

Thanks, @Anonymous! That worked!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.