Chart value not updating properly

[Anonymous]

Hello everyone,

I am new to creating Power BI reports and have recently developed one that includes data from the past two years (2023 and 2024). My goal is to display only the current year's values in the chart, but I’m experiencing an issue where the values get mixed up, when I use the slicer to select a year and month. For instance, when I select the year 2024 and the month of July (which should show 50), the values also incorporate data from July 2023, leading to a total of 100 instead of just 50.

Additionally, I've set up a Many-to-Many relationship for the months across reports, but it doesn't seem to function properly. Could someone please advise me on how to resolve these issues?

Thank you!

Best regards,
KPS

[Anonymous · Accepted solution]

Hi @Anonymous ,

I create a table as you mentioned.

Then I create a new table.

DateTable = 
ADDCOLUMNS(
    CALENDAR(DATE(2023, 1, 1), DATE(2024, 12, 31)),
    "Year", YEAR([Date]),
    "Month", MONTH([Date])
)

The relationship between them is One-to-Many.

When I add a slicer it will give you what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You need to understand the need for a many-to-many join. It should be avoided depending on what you are building.

Bridge Table

https://www.seerinteractive.com/blog/join-many-many-power-bi/

Common Dimensions

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda