Forum Discussion
TonyBI
Helper I
Helper IVisualisation 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): ...
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,
TonyBIHelper I
Helper IDear 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
Microsoft Employee
Microsoft EmployeeHi 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,