Annual data turn up as same total instead of annuals.

[Powerbilly]

For a given company, I have five years of sales data, totalling to 7 m dollars.

In the bar chart (or any other visual)  I see 7 m dollar for every year, instead of the different annual sales numbers.

What do I miss here? Great many thnaks.

[MFelix]

Hi @Powerbilly,

Are you using a calendar table?
If yes did you create a relationship between both tables?
What columns are you using as axis?

Regards,
MFelix

[Powerbilly]

Thanks for the fast reaction.

No, just basic input from a simple excel worksheet.with the years in column a and sales in column b.

Years are in the x axis. 

I also used the data in an other already existing table, with corect display, but totals flipped to 7 m totals for each year.

I guess I am overlooking something basic. Thanks in advance.

[MFelix]

Can you share sample pbix file?

[Powerbilly]

When deleting pages and query columns to simplify the example file for you, the visual was blank and required to click the 'solve this' button.   

It then was indeed correct.

I will now proceed eliminating pages etc. to see if I can replicate this without damage for my other pages.

Unless this rings a bell with you?

Thanks once more.

[MFelix]

Hi,

What columns are you using on that specific visual?

Regards,
MFelix

[Powerbilly · Accepted solution]

I made a beginners mistake and mixed up variables from different imported data sets.

My apologies to all of you.

Topic closed.

[MFelix]

Glad you were abble to solved it.

Regards,

MFelix