Power Bi related question

[hussainsialkot]

Hi guys. Really need your help on this.

I'm using power bi for a presentation. I have comparative data for two years imported by way of two different excel tabs into power bi. When I'm trying to create a comparative bar chart on an entity by entity basis, i.e. showing revenue for each entity in the bar chart for each year separately, for one of the two years it is showing me the same cumulative revenue in each entity, instead of showing revenue for each entity separately. i have tried all options but am unable to solve this. Please someone help me out.

Regards.

 

[cyrilbrd]

Hi, maybe you could help readers understand a bit more, are the two tables identical (column headers), what are your measures, what are your relationships, and maybe a small sample of what you have and what you would like to see.

 

[hussainsialkot]

I have basically two different tables. Having different column headers and different data. The common denominator in both would be the dates. I would like to link them in a way so that I can plot data from the different tables on the same visual, using the common dates. Hope this clarifies it a bit.

 

[cyrilbrd]

Maybe creating a separate table for the unique date so this could help you link those two tables.
Your added Calendar table will contain a unique list of dates so you could properly set your relationships.
You may follow this example.