- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Last 12 Months or Reporting Month based on Month and Year Filters
I have a Month slicer and a Year slicer on my dashboard, which interact with the data displayed:
Now, I added a "Period" slicer where the user can select the following:
- Last 12 Months
- Data displayed should be last 12 months from the Month and Year selected.
- Ex: Selecting March and 2024 should display the data from April 2023 up to March 2024.
- Reporting Month
- Data displayed should be based on the Month and Year selected.
- Ex: Selecting March and 2024 should display the data from March 2024 only.
Right now, the dashboard functions as "Reporting Month" only where the data displayed are from Month and Year selected. How do I make the Period slicer functional?
PBIX: Sample_PeriodIssue.pbix
Given the sample pbix, here's the expected results:
Last 12 Months - March - 2024:
Reporting Month - March - 2024:
PBIX: Sample_PeriodIssue.pbix
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello @JustParagon , and thank you for sharing a question with the Community. The following is informational. Please remember to adhere to the decorum of the Community Forum when asking a question.
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-23-2024 01:29 PM | |||
08-01-2024 08:00 PM | |||
09-27-2024 04:21 AM | |||
07-30-2024 05:40 PM | |||
08-07-2024 05:54 AM |
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |