Forum Discussion
Post ProdigyVisual 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 Operacine veikla row per month and total.
I used this formula for counting:
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
3 Replies
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - Ashish_Mathur
Hi,
Ensure you have a Calendar Table. Create a relationship (Many to One and Single) from the Date column of your Table to the Date column of the Calendar Table. Write calculated column formulas in the Calendar Table to extract Year, Month name and Month number. To your visual/filter drag Year and Month Name from the Calendar Table. Write this measure
CF operacinis CF kaupimas daugiau nei Y = calculate([CF operacinis CF],datesytd(Calendar[Date],"31/12"))
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
