Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Visual doesn't correspond to table data in Power BI

Hello,   I am creating a line chart in Power BI but values in line chart don't correspond to table data. Why it happens? I am calculatince cumulative sum. That values are different than in ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Analitika,

    Did you create any relationship between the table Data and fact table? Please try to update the formula of your measure [CF operacinis CF kaupimas daugiau nei Y] as below and check whether it can return the correct result.

    CF operacinis CF kaupimas daugiau nei Y =
    CALCULATE (
        [CF operacinis CF],
        FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
    )

    In addition, you can refer the following links to resolve your problem.

    Calculating Cumulative Totals for Time Periods

    Cumulative Totals Only Up To Specific Dates - DAX Tutorial For Power BI

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards