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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

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.
 

Forum statistics

Threads
1,089,195
Messages
5,406,738
Members
403,105
Latest member
gituncar

This Week's Hot Topics

Top