Forum Discussion

aksharacoomar's avatar
aksharacoomar
Icon for Helper I rankHelper I
5 years ago

Mimic Excel Pivot table in PowerBI

Hi all,   I am building an Actual vs. Plan report on PowerBI which we currently have on Excel. Although I have most of the things I need in the right form, I do have some trouble areas pertaining t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi aksharacoomar 

I build two kinds of data models and both of them works well.

Data model1:

data model2:

Result:

Could you show me your data model and tell me more details about how did you build you matrix visual?

Or you can share your pbix with me by your Onedrive for Business.

 

Best Regards,

Rico Zhou

 

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