How to create comparison visualisations based on 2 data models.

[InesaL]

Hi all!
I have to compare the current week's values with those from 2 weeks ago. The variables/columns in these 2 datasets are the same. Consequently, I have 2 similar data models. How to create a visualisation that compares, for example, the number of items per category from 2 weeks ago and from the current week?
Should I unify somehow these 2 data models?
Thanks!

[Anonymous · Accepted solution]

Hi @InesaL ,

To compare the number of items per category from two different data models in Power BI, you can use the "Append Queries" feature to combine the two data models into a single table.

Append queries - Power Query | Microsoft Learn

Note that if the columns in the two data models have different names, you will need to rename them before appending the tables. Also, make sure that the data types of the columns match in both tables.

You can create a scatter plot in Power BI to compare the number of items per category from two different datasets.

Current Week = SUM('Current Week'[Number of Items])

Two Weeks Ago = SUM('Two Weeks Ago'[Number of Items])

You can add these measures to the scatter plot as X and Y axes.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[johnyip]

Just load all those dataset in your pibx, and establish relationships that exists between the tables in the same dataset.

You should have two stanfalone datasets in your pibx by then.

After that, depending on you data and need, create some calculated columns / measures that meet your needs.