Visulisations not caluculating correctly

[tylerdv]

Hey all,

Having a really weird issue with 2 out of 7 visulisations i have going...

For some reason all the weekly values are coming back with the same result? 

What i have done 

Calculated weekend from date

Put WeekEnd as axis

Put sales as values

Hit 'Sum'

I cannot work out why this is failing - as the above works for other graphs but not this one!

Any help would be appreciated

[Phil_Seamark]

Hi @tylerdv,

9 times out of 10, this is happening because there isn't a relationship between the fields you are using for the Axis of your visual, and the fields you are using in the Values.

Can you please show more detail about the tables you are using.

[Eric_Zhang]

@tylerdv

I don't reproduce that issue. Could you be more specific on what is the data in your pbix. Even better you could share the pbix to help to reproduce the issue.