Forum Discussion

tylerdv's avatar
tylerdv
Frequent Visitor
9 years ago

Visulisations not caluculating correctly

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

Need Help

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    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.

     

     

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    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.