Using a measure to change data to weekly or monthly date range

Hi albertax ,

You can refer the following links to get it.

Change time period (week, Month, Quarter...) on slicer selection

Power BI How To: Adding a Monthly/Annual switch to a Dashboard

Measure to show the data as "daily","weekly","monthly" in power bi?

---

There are 2 common ways to make this work :

Way-1 : Utilizing Power Query

1. Create a "Date Table" using the date column in power query
2. Add 3 calculated columns that extracts month, week and day info from the "Date" column in the newly created "Date Table".
3. Now, unpivot the "month", "day" and "year" columns and load the file.
4. Create a one to many relationship with "Date" columns as common in both tables and there you go.

Way-2 (Using Drill-through buttons).

Use the recent feature update of Power BI, i.e., drilling the data using buttons. So, you just need to create a date hierarchy and then drill through using buttons for "month", "week"and "day".

I hope this will help you.

If you still got the doubt then please send me the dataset and I will give you an detailed explanation on this.

---

Best Regards