Reply
PBrainNWH
Helper II
Helper II
Partially syndicated - Outbound

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?

PBrainNWH_0-1721256702717.png

 

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

Syndicated - Outbound

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

View solution in original post

1 REPLY 1
v-heq-msft
Community Support
Community Support

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)