Forum Discussion
Solved
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
Thank you guys for try to help!
Diogo Afonso
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
Thank you for trying !
Diogo Afonso
1 Reply
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
Thank you for trying !
Diogo Afonso