Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Chart value not updating properly

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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies