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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
DAFONSO
Frequent Visitor

Appear only weekdays in my visual

Hi everyone!

I don't think if is possible or not. But i'm trying to have just weekdays on my bar graph. 
I know the easy way is delet the informacion of my data base, but i don't want the because my data base is refreshing every day.

 

So i asked if you now any formula or measure can help me to delete the weekends and just show the weekdays.

I know the new formula NETWORKDAYS, but is not what i want, is similar 

 

DAFONSO_0-1689155806955.png

 

 Thank you guys for try to help!
Diogo Afonso 

1 ACCEPTED SOLUTION
DAFONSO
Frequent Visitor

I resolve the problem, i create a new colum with this measure 

"Weekdays" = IF(AND(WEEKDAY('Calendário'[Date]) >= 2, WEEKDAY('Calendário'[Date]) <= 6), 1, 0)"
and then i put in the filter and then i filter by 1, just showing me the weekdays 


DAFONSO_0-1689159336866.png

 

Thank you for trying !
Diogo Afonso 
 

View solution in original post

1 REPLY 1
DAFONSO
Frequent Visitor

I resolve the problem, i create a new colum with this measure 

"Weekdays" = IF(AND(WEEKDAY('Calendário'[Date]) >= 2, WEEKDAY('Calendário'[Date]) <= 6), 1, 0)"
and then i put in the filter and then i filter by 1, just showing me the weekdays 


DAFONSO_0-1689159336866.png

 

Thank you for trying !
Diogo Afonso 
 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors