How to create a graphs with no weekend visible

[Frixel]

Hello

I would like NOT to see the dates/days of the weekend, so Saturday(12-4) and Sunday13-4), not in the graph.
How can I do that so that only the working days are visible?

[HarishKM]

@Frixel Hey,
I am using this calender in my Power bi report.

Calender = ADDCOLUMNS(CALENDAR(DATE(2000,1,1),DATE(2060,12,31)),

"year",YEAR([Date]),

"Month", MONTH([Date]),

"Month-year",FORMAT([Date],"MMM-YY"),

"Qtr",QUARTER([Date]),

"QTR-YY","Q"&"-"&FORMAT([Date],"YY"),

"IsWorkingDay",

        IF (

            WEEKDAY([Date], 2) <= 5,  // 2 = Monday as the first day of the week (1 = Sunday, 7 = Saturday)

            "Yes",

            "No"

        )

    )

I hope this will solve your requirement.

Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[Frixel]

Hi @HarishKM 

i do that here?

[HarishKM · Accepted solution]

@Frixel
step 1:  Kindly create a new table then paste my code over there.

step 2:create a active relationship with newly create calandar with your fact table 

Step 3: Drag month year field from calendar in X axis.

Step 4: select visual and then drag isworking day in filter section and then select No to filter record like below

if you follow above steps then it will fulfill your requirement.

Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[Frixel]

i still see the weekend dates in the graph.

[Frixel]

@mdaatifraza5556 & @pankajnamekar25 

Do I create that new column in the existing query or do I create a new query for it?

[mdaatifraza5556]

Hi @Frixel 

As you have a date column,,,,,,,,,,, in the same table add calculated col "isweekday" and drag that to visual level filter to show only weekday data.

As you can see below I created with some sample data.

If this answers your questions, kindly accept it as a solution and give kudos.

[pankajnamekar25]

New column and that column yiu will add to visual filter.

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[mdaatifraza5556]

Hi @Frixel 

Can you please try the below steps :

1. Create calculated column by using below DAX
              IsWeekend = IF(WEEKDAY([Date], 2) > 5, "Weekend", "Weekday")

2.  Drag IsWeekend  on visual level filter and set it to "Weekday" only.



If this answers you questions, kindly accept it as a solution and give kudos.
          

[pankajnamekar25]

Hello @Frixel 

You can create a calculated Column in your Calendar table

IsWeekday = WEEKDAY('Date'[Date], 2) <= 5

Add visual level filter using created column

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.