not plotting two data source

[papuzu]

hello Guys

I've uploaded 2 tables. Both figures of two reporting years (supposing year 1 and 2). When I'm trying to plot it the second column (year 2) is reported as total (sum) all over the rows compared to column of other table (two tables, same rows just changing year of analysis) 

it seems pretty straightforward and in the examples provided all worked smoothly 

thanks

[papuzu]

Hello There 

Im posting the question after I've been trying to sum up the query with dummy data. 

Basically when I'm uploading onto powre-bi desktop an excel with 2 sheets with 2 same table size representing products sold for some different brading I cant simply filter them in a chart because one of the two column is represented as sum of data . please see images attached

[V-lianl-msft]

Sorry, the picture you provided is too vague to get valid information.

Please see the blog:

How-to-provide-sample-data-in-the-Power-BI-Forum 

You'd better add some pictures or descriptions of the results you expect.

[papuzu]

I cant post anything because of HTML error while I add simply attached a table of data following instructions. What's wrong? 

Now I could reply. I'll post a screenshot of error

Edit . This is the error

[papuzu]

Example of plotting data 

Hello there , i've been able to create an example and post it on a shared folder 

would you be able to see it ? 

I cant understand why when plotting two tables with common parameters the second table is summarized per each rows. 

thanks for helping 

[papuzu]

Ok. I've been able to set up some spare data. What best way to share then ? I cant find attachment chance in here, let me know whether would be enough to copy them on a table or get screenshots. Thanks

[V-lianl-msft]

Hi @papuzu ,

You need to create a new calendar table and create relationships with the other two tables.

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[papuzu]

thanks there 

I dont have to create a calendar joint. I'll try to post an example but also with dummy data power-bi desktop crash . is this anyhow normal ? this is happening frequently, my laptop is full of power and nothing crazy opened/happened with other office packages I'm using. This is getting critical operating issue

cheers

[selimovd]

Hey @papuzu ,

can you provide some sample data and how the result looks like?

This makes it easier to help you.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[papuzu]

I was trying to post but as you read above I'm struggling with power-bi continuos crashing