- 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
Creating a filter to only show items which have changed week to week
Hi,
I'm in the process of creating a matrix visual. The matrix visual shows values for 2 seperate weeks. However, I want the table to only show values where theres been a change week to week.
I've created a quick Excel sketch to help with understanding. In the below example, we would not want "A" to appear in the matrix visual as theres been no change week to week
Thanks gurus!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
- Would you always select only 2 weeks in the slicer?
- Share the download link of the PBI file with a Calendar Table already built in. Ensure that there is a week number column in the Calendar Table
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
We would like the default to always show the 2 most recent weeks.
I do not have an option to attach an pbix unless im mistaken. I've added a screenshot FYI.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Share the download link of the PBI file. Also, in that file, ensure there is a Calendar Table with a Week column.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
There should be a Date column in the Opportunity Table as well. If you do not have a Date column but just a Year and Month column, please share those columns in a revised file.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Sorry but i cannot work it out.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
no worries, thanks for having a go 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the download link seems to have expired.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
this is great! The only thing is it doesnt change when the week changes.
Would you mind just explaining what is happening in the measure in simple terms?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
in the current filter context find the penultimate date. Then for that date find the value. Then compare that value to the value for the ultimate date. Use the resulting measure as a visual filter.
You can choose how many data points to include, it will always compare the last two.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
your data is not in a usable format. Unpivot it first, then create your measure.
What should happen when you add 2023-07 data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The data is unpivotted. Lets assume the data is in the following format:
Name, Week, Value
A, 2023-06, 50
A, 2023-07,45
etc
The screenshot is more a representative of the end goal.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-21-2023 09:40 AM | |||
06-24-2024 08:39 PM | |||
11-10-2023 11:40 AM | |||
05-21-2024 07:42 AM | |||
10-26-2023 11:20 PM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |