Forum Discussion
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!
see attached.
16 Replies
- lbendlin
Super User
your data is not in a usable format. Unpivot it first, then create your measure.
What should happen when you add 2023-07 data?
- Ashish_Mathur
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
- lbendlin
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-p/963216
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
