Forum Discussion

InesaL's avatar
InesaL
Regular Visitor
3 years ago
Solved

How to create comparison visualisations based on 2 data models.

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 v...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
johnyip
Solution Sage
3 years ago

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.