Showing Last week,month and quarter Data Dynamically

[Anonymous]

Hello All,

I have a report where I am having 3 pages which have 10 visuals in each page.

In one page I need to show last weeks data

In one page I need to show last Month data

In one page I need to show last Quarter data.

For weekly page Like If the user run report anytime in this week I need to show data from 11th June to 17th June.(Previous week)

For Monthlypage Like If the user run report anytime in this month .I need to show data from 1st may to 31st may.(Previous month)

same for quarter (Jan to Mar)

Could any one please help how to do this.

[Dhairya]

Hey @Anonymous 
This can also be achieved using page level filter as shown below screenshot, Use the date column from the date table or your dataset for using it in page level filter.

If this helps please mark my solutions as accepted!

[Anonymous]

Hi @Anonymous ,

try below steps

• Create a Date table: Ensure that you have a Date table in your data model that includes a column with a unique date for each day. If you don't have one, you can create it using Power Query or manually in Power BI Desktop.

• Create measures or calculated columns: In the Date table or any relevant table, create measures or calculated columns to determine the start and end dates for the desired time periods. Here's an example for the weekly page:

  • Weekly Start Date:

    DAX
• Weekly Start Date = CALCULATE(MIN(DateTable[Date]), PREVIOUSWEEK(DateTable[Date]))

• Weekly End Date:

  DAX
• • Weekly End Date = CALCULATE(MAX(DateTable[Date]), PREVIOUSWEEK(DateTable[Date]))

  Similarly, create measures or calculated columns for the monthly and quarterly pages, replacing PREVIOUSWEEK with PREVIOUSMONTH and PREVIOUSQUARTER, respectively.

• Apply relative date filtering: On the pages where you want to show the last week, last month, or last quarter data, apply relative date filtering to the visuals. Follow these steps:

  • Select the visual you want to apply the filter to.
  • In the Visualizations pane, go to the Filters section.
  • Click on the "Add a relative date filter" icon (calendar with a clock).
  • Choose the relevant date column (e.g., DateTable[Date]).
  • Select the appropriate relative date filtering option (e.g., "In the previous" and set the value to 1 for last week, 1 for last month, or 1 for last quarter).
  • Apply the filter to the visual.

• Repeat step 3 for all visuals on the respective pages to apply the relative date filtering consistently.