I can't exclude weekends from visual in Power BI

[Analitika]

Hello,

I would like to ask how I could exclude weekends from the visual. X axis contains a column date of weekdays but in the visual I still see gaps of weekends in visual, so how fix this issue?

18 and 19 days are weekend.
Here is a measure visual calculation:

[ADDHOPE]

Hi,

You can change the X-axis type to Categorical instead of countinous. 

Regards

[v-eqin-msft · Accepted solution]

Hi @Analitika ,

It's weird.

Please create a flag measure:

Measure = IF(WEEKDAY(MAX('Table'[Date]),2) in {6,7},1,0)

And drag it to filter pane :

If it does not work as well, please provide a sample to help us clarify your scenario since you actual data is sensitive.

Change how visuals interact in a report - Power BI | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ALLUREAN]

In your date table if you have IsWeekday flag (1,0) then you can try using it as a filter in your visual to 1. Just a suggestion, not sure if this will help without look at your real data.

[Analitika]

I also tried this but it didn't change anything, not works as before

[Analitika]

Hello,

Hello,

I would like if possible to exclude blank dates from visual, I made calendar table witch contains data without weekends but whener I use that date column in visual I still see gaps between dates in visual. So how resolve this issue?

I marked the gap using blue marker. I can't a solution in order to exclude blank dates.

[amitchandak]

@Analitika , use a visual level filter , measure <> 0

[Analitika]

Not helped. I tried filtering like you said mentioning a mesure <>0 

[Analitika]

Yes I did but it didn't change, didn't affect the visual.

[VahidDM]

Hi @Analitika 

Can you share your PBIX file?

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Analitika]

Why filtering don't affect visual?

[Analitika]

No, I can't, it contains a lot of sensitive data.

[ALLUREAN]

Hi, @Analitika 

Did you try drop your measure into visual filter and set as Is not blank?

[richrich123]

Did anyone get this to work? I have the same issue, the suggested method doesnt seem to have any effect on removing the weekend gaps where there is no activity?

[Jooster]

Your measure is 0 for weekends, but your filter removes blanks. And PowerBI sees 0 as different from blank. Choose one of A and B:

solution option A: make your measure weekend return 1 or BLANK()

solution option B: filter by explicitly keeping only 1