Forum Discussion

TonyBI's avatar
TonyBI
Icon for Helper I rankHelper I
7 years ago
Solved

Visualisation Append

Dear friends, I need your help with this:   I have a number of tables with the same data but different filters and metrics, as shown below (tables don´t have any relationship - this is mandatory): ...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
7 years ago

Hey,

 

maybe the append function from Power Query is something you might want to investigate. A very good start about this functionallity is this article:

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

You have to be aware, that the combination of tables (necessary to visualize the whole content in one visual) is only possible during the execution of the Power Query queries or when the data is refreshed. It is not possible to create the table if a user selecte a different value from the slicer. This may have an impact on your table design, due to the slicers in your example.

 

Hopefully this helps to answer your question.

 

Regards,

Tom 

TonyBI's avatar
TonyBI
Icon for Helper I rankHelper I
7 years ago

Dear Tom, thx for you response. Unfortunately, the append function in the query editor is not an option. This is because every table that I mentioned have different parameters (column parameter) that are calculated with differents filters, that´s why I need to be able to append the visual objects, not the tables.

 

THX!

 

Tony

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi TonyBI 

    You may use 'Unpivot columns' for each tables' Metric column first.Then append them and add a custom column as attached sample file.

    Regards,