cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Powerbilly Frequent Visitor
Frequent Visitor

Annual data turn up as same total instead of annuals.

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Powerbilly Frequent Visitor
Frequent Visitor

Re: Annual data turn up as same total instead of annuals.

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

My apologies to all of you.

 

Topic closed.

View solution in original post

7 REPLIES 7
Super User
Super User

Re: Annual data turn up as same total instead of annuals.

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Powerbilly Frequent Visitor
Frequent Visitor

Re: Annual data turn up as same total instead of annuals.

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.

Super User
Super User

Re: Annual data turn up as same total instead of annuals.

Can you share sample pbix file?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Powerbilly Frequent Visitor
Frequent Visitor

Re: Annual data turn up as same total instead of annuals.

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.

Super User
Super User

Re: Annual data turn up as same total instead of annuals.

Hi,

What columns are you using on that specific visual?

Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Powerbilly Frequent Visitor
Frequent Visitor

Re: Annual data turn up as same total instead of annuals.

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

My apologies to all of you.

 

Topic closed.

View solution in original post

Super User
Super User

Re: Annual data turn up as same total instead of annuals.

Glad you were abble to solved it.

 

Regards,

 

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 153 members 2,059 guests
Please welcome our newest community members: