Combining rows in Power BI

Question

Hello,&nbsp;I am trying to complete what is an easy excel task in Power BI.&nbsp; I have a basic table in Excel that I also recreated in Power BI that looks at the weekly numbers. Below is a screenshot of that report:&nbsp;&nbsp;For each column, I completed a DAX calculation to get the last 10 week average, the difference between the last 10 week average and the current week, and the percentage change difference.&nbsp; What I'd like to be able to do is create a row for each&nbsp;measure in Power BI and have the rows bound to one another in one table (I realize I probably won't be able to filter them, which is fine).&nbsp; Below is a screenshot of what it looks like currently in Excel.&nbsp; Basically I was hoping to recreate this in Power BI.&nbsp;&nbsp;Any help is greatly appreciated.&nbsp;Regards,Bill Farrell

v-piga-msft · Answer

Hi&nbsp;wfarrell,
&nbsp;
Have you solved your problem?
&nbsp;
If you have solved, please&nbsp;always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
&nbsp;
Best Regards,
Cherry

anonymous · Answer

Hi&nbsp;wfarrell,see if the post from Matt helps you in displaying measures in rows.&nbsp;https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/&nbsp;RegardsCLR&nbsp;&nbsp;

Forum Discussion

Combining rows in Power BI

2 Replies

Related content

Combine 2 rows into 1

Tables combine

Combining similar rows

Combine values from multiple rows

combine power bi reports