Power Bi related question

hussainsialkot

New Member
Joined
Jan 16, 2020
Messages
2
Office Version
2019
Platform
Windows
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.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
365
Platform
Windows, Mobile
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

New Member
Joined
Jan 16, 2020
Messages
2
Office Version
2019
Platform
Windows
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

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
365
Platform
Windows, Mobile
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,243
Messages
5,413,280
Members
403,472
Latest member
ArtisticOwl

This Week's Hot Topics

Top