Forum Discussion
Solved
Group / Slice metrics
Hi, I'm new to Power BI (used other BI softwares in the past). I'm trying to figure out if it's possible to do the following. Is it possible to group metrics so we can slice by these groups in ...
Hi francogf,
Here are detail steps to join those two tables:
1. In Query Editor, select columns from "Metric1" to "Metric5", then click Unpivot Columns.
2. Click Merge Queries as New to get a joined table.
3. Expand columns.
You can download attached .pbix file to have a look.
Best Regards,
Qiuyun Yu
Hi francogf,
Here are detail steps to join those two tables:
1. In Query Editor, select columns from "Metric1" to "Metric5", then click Unpivot Columns.
2. Click Merge Queries as New to get a joined table.
3. Expand columns.
You can download attached .pbix file to have a look.
Best Regards,
Qiuyun Yu
Thank you very much for the detailed instructions :-)