The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Team,
Can we merge the cell data in power bi. I mean how we do in Excel. PFB existing data and required output
Existing data :
Country | City | Year | Sales | Target Reached |
IND | Hyd | 2016 | 500000 | Yes |
IND | Hyd | 2017 | 400000 | No |
IND | Hyd | 2018 | 70000 | Yes |
IND | Blore | 2017 | 550000 | Yes |
IND | Blore | 2018 | 650000 | Yes |
US | AZ | 2018 | 700000 | Yes |
US | AZ | 2017 | 400000 | No |
US | AK | 2017 | 5000000 | Yes |
US | AK | 2018 | 34000 | No |
Solved! Go to Solution.
Hi @Narukkp ,
You can implement it using a matrix.
Drag the column to the Fields -- > turn off the option of Stepped layout -- > turn off the option of Row subtotals -- > expend all down one value in the hierarchy
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! I tried implementing this solution and I no longer see within the matrix view.
Hi @Narukkp ,
You can implement it using a matrix.
Drag the column to the Fields -- > turn off the option of Stepped layout -- > turn off the option of Row subtotals -- > expend all down one value in the hierarchy
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Xue Ding,
I have tried your instructions (Off 'Stepped layout', Off 'Row Subtotal' and Click on 'At the lowest level of data') but the result shows only 1 row (instead of 4 rows as in the below images).
Please help to check.
Thank you so much.
Kha
Thank you
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |