r/PowerBI•
awk13

Showing values in a table visualization from multiple data tables

Question

I have two data tables that contain separate information about locations for a business. One table contains information related to customers and another contains information related to financials for each location. I am aggregating the data at the location level and trying to display data for both tables on the same table visualization, but when I add data from the second table it is only displaying the overall measures for that table and not dividing it up by location like if I only have data from one table on the visualization. A join isn’t really appropriate here I don’t think because the data isn’t really related besides me wanting to display it at the same level on the same vis and the two data tables have vastly different number of rows.

Posted Feb 8, 2022, 4:36 PM UTC

56
Financial_Ad1152•

If it’s not related then it shouldn’t go in a table together. Customers and locations would usually be related by where a customer purchases from. So you’d have Location > Customer > Sales for that customer and location (as an example).

5
awk13OP•

What I meant by not related was that the data in each table are looking at different scales. One table is looking at the customer level and has 50k rows. The other table is looking at a monthly level for financial information and is 1k rows. Every row on both tables contains a location identifier I am aggregating by. My “summary” table contains a count of customers at each location and also needs to contain a sum of the financial information at each location. I am able to do this easily in two separate visualizations but am running into issues when attempting to combine them in to 1 visualization

1
Financial_Ad1152•

They need to be related. It sounds like you have progressed to the visualisation stage of development too early, I would go back and get your data prep/modelling sorted first. This sounds like you can do a star model, with a central fact table, a location dim and a customer dim.

5
awk13OP•

Not possible for me to change the data model. Guess I will proceed with separate visualizations. Thanks!

1
andres5000•

You can create a mess if you mix data like that. Think about how the quantitative data can be totalized if it has duplicates.>!!<

1
Financial_Ad1152•

Wasn’t suggesting they mix it. In my other reply it sounds like the data model hasn’t been scoped out for this kind of visualisation.

1
[deleted]•

[deleted]

1