Forum Discussion

STEPH0018's avatar
STEPH0018
Icon for Helper II rankHelper II
4 years ago
Solved

remove not working days dates from bar graph

Hi guys I would like to know if it is possible to remove blank spaces, from dates that are not working days and I don't have in my base, from a bar graph. I didn't want to put the x axis as categori...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi STEPH0018 ,

    You can create a column.

    Weekday=var _weekend=weekday(table[date],2)
    return
    if(_weekend>=6,blank(),1)

    Then filter the column.

    Click the column is not blank.

     

    I have found a post about holidays. Please refer to it to see if it helps you.

    Calculate Working Days in Power BI 

     

    Best Regards

    Community Support Team _ Polly

     

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