Forum Discussion

rdops's avatar
rdops
Helper III
6 years ago

Visualise two different data sets in one chart

Hi all,  I am totally new to PBI, have been exploring it for approx 1 month now and still have very limited knowledge. I hit a wall while trying to combine/visualise  two sets of data from differen...
Need Help
rdops's avatar
rdops
Helper III
6 years ago

Hi Maggie,

Thanks for your reply. See data below.

The green data is the leave hours entered on system A, red data is leave entered in system B. Each system is a separate Excel sheet and they should all have the relevant relationships. Eg, Employee (on system A) and Worker (on system B) are connected.

Months are also connected on both systems.

 

If you look at the chart with two bars (191.2/171.25), this is the total leave on each system, side by side in one single chart, like I wanted. However, when I filter by 'Worker', and have the chat by month, only one data set (red) displays properly. The other data shows the exact same number across the months.

Note that some people entered leave on system A but didnt enter on System B, this is why I need this report, to compare what is showing in one system and not the other. This is the ultimate result I want, to have both data side by side, by month, and by employee. I found a way to visualise it, which does the work, but I am sure there is a way to do it properly. What I did, I  created two chiclets slicer for the months, one chiclet per system, so when I need to compare month by month, I select the worker and then click on the filter/month for system A, and filter/month for system B. This way I see them both, but on two distinct charts, as opposed to the same chat, side by side. Hope it makes sense? Month by month data (only one set of data gets updated)two filters to compare data by month

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi rdops 

    One method is to append two tables in one table. 

    In Edit queries,

    add a custom column in "system a" table

    system="system a"

    add a custom column in "system b" table

    system="system b"

    Change the column name "worker" to  "employee" in  "system b" table

    Append a new query, 

    Uncheck "enable load" for "system a" table and "system b" table,

    So finally, clseo&&apply, we see only "append" table to show on data model view.

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.