Forum Discussion
Helper IPivot table in Power BI
Hello,
I am trying to create a pivot table-like structure in Power BI. I currently have the output prepared in Excel and now need to replicate or implement it in Power BI.
Could anyone guide me on how to approach this?
My data look like this:
And here is my expected output:
As a newcomer to Power BI, I would greatly appreciate your assistance. Thank you!
7 Replies
- danextian
Super User
Inforiver has a pretty good custom matrix visual that might be able to replicate this but it comes with a subscription based on the number of users. This is possible with the native matrix viz up to a certain extent so certainly it can't look like that.
AmyriesThank you for your response!
- suparnababu8
Hi Amyries
Could you pls share your data in the form of editable text/upload csv file, not in the image. So we'll try to help you
Hi, Amyries
Measure can't be put into the rows of a matrix, and this is the best way to display them.
Sum = SUM('Table'[Price])Amount = COUNT('Table'[VOUCHE])Does this solve your problem?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Amyries
Thank you for the great solution, but my requirement is still displayed as the expectation above
