Relative data begin to Monday until Sunday

[XaviOV]

Hi,

I'm working with a "Clustered column chart", and I'm filtering by "Relative filter" in this week, but the week of Power begin in Sundayand I would like that the week will begin in Monday.

How I do it?

Regards,

Xavi

[Pragati11]

Hi @XaviOV ,

I think I got a work-around of achieving this.

I have a sample data with 2 columns:

I added two columns to this using following DAX expression:

Day name = FORMAT(Sheet1[Date], "dddd")

DayNum = WEEKDAY(Sheet1[Date],2)

The final data is as follows:

I sorted "Day Name" column by "DayNum" column as follows:

Then I created a Clustered bar chart as follows:

Then further applied a Relative date filter to display data for last week:

Just let me know if this is what is required.

If this helps appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[XaviOV]

Hi @Pragati11 ,

Yes, but in this case the value of Monday is the value of the last week no of the current week 😞

Regards,

Xavi

[Pragati11]

Hi @XaviOV ,

Apologies, didn't understand your question.

You can use Relative Date filter for slicing data for current week, last week, etc.

If this helps appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

You can refer this file how to deal with week from Monday to Friday

https://www.dropbox.com/s/a9xq913pgvuzg2x/sales_analytics_weekWiseMon_sun.pbix?dl=0

Appreciate your Kudos.

[XaviOV]

Hi @amitchandak , @Mariusz and @Pragati11 

I attachment a picture, I'm filtering the column chart by a week ago but the week begin to Sunday until Monday, and would like that the week begin to Monday until Sunday. In the column chart appear the last Monday (Domingo in spanish)

Regards,

Xavi

[Mariusz]

Hi @XaviOV 

As mentioned in my previous post, what you asked of can not be achieved currently with relative filters, so please refer to both links I have posted previously.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Pragati11]

Hi @XaviOV ,

Is it possible for you to share this pbix file?

Thanks,

Pragati

[XaviOV]

Hi @Pragati11 ,
My company does not allow it, what do you need?

I am sorry,

Xavi

[Mariusz · Accepted solution]

Hi @XaviOV 

By the look of, this option is not yet available in Power BI, but you can vote for it here.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20248087-relative-date-filter-wee...

As an alternative, you can build a Relative Date Dimension as per below article where you can specify the start of the week.

https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039

Just adjust week to start on Monday
Date.WeekOfYear( date, Day.Monday )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Pragati11]

Hi @XaviOV ,

Have you got a caluclated column for Week Number in your data? If yes, then use the "WEEKDAY" dax function with "return_type" = 2, to start your week with Monday.

Refer following for detail:

https://docs.microsoft.com/en-us/dax/weekday-function-dax

If this helps appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati