- 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

Values replicating over months in Matrix
What can I look for to fix this issue where my July numbers are replicating in each of the subsequent months?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @PBrainNWH ,
Based on your description, your data carried out a duplicate after July. This may be due to the fact that the data was not filtered in the context of columns, only rows were applied. So the aggregation was done with row categorization. If Actual is a measure, you can use calculate and alexcept to sort by month.
The above is speculation based on the screenshot you provided, if you want to get more detailed help, you can provide example data, preferably a pbix file. Please hide sensitive information in advance.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @PBrainNWH ,
Based on your description, your data carried out a duplicate after July. This may be due to the fact that the data was not filtered in the context of columns, only rows were applied. So the aggregation was done with row categorization. If Actual is a measure, you can use calculate and alexcept to sort by month.
The above is speculation based on the screenshot you provided, if you want to get more detailed help, you can provide example data, preferably a pbix file. Please hide sensitive information in advance.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-19-2024 10:49 PM | |||
09-30-2024 04:00 AM | |||
Anonymous
| 03-27-2024 01:16 AM | ||
03-25-2024 10:06 AM | |||
10-09-2024 08:12 AM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |