Forum Discussion

muthusaran's avatar
muthusaran
Regular Visitor
3 years ago

MS Excel Pivot to Power BI

I'm new to Power BI and while learning it, I tried to replacate few existing Microsoft Excel Pivot in PowerBI and succeeded. One of the attached Pivot couldn't be replicated in PowerBI. Please help m...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi muthusaran ,

Please refer to my pbix file to see if it helps you.

 

Please learn more about matrix in power bi: Create a matrix visual in Power BI - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

muthusaran's avatar
muthusaran
Regular Visitor
3 years ago

Thanks for the effort.

 

I need this similar to Excel pivot.

If we have future period, it will keep on appending and we need to drag to right side which is not expected.

Expected Matrix/Table in Power BI: (Same as Excel Pivot below)

 

  

Below is the Pivot in Excel looks.

 

PBIX File: I don't see an option to upload. But, my PBIX looks like below

 

 

But, My visualization in my pbix is like below