Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II
Helper II

Design customized reporting

Dear friends


I have question regarding designing a report in power bi. Assume that we have query data table like the below picture in pbi:




Now ,I would to create  a report to calculate numbers of orders for each "week" based on "product grouping".I have designed the report in the excel as below, do you think,this shape of report exactly can be designed  in pbi reporting as well? Actully I think the structure  of PBI can not let me to do like below ( diffrent weeks at the top),any soloution?



Thank you



Not applicable

Did you Try a "Matrix" chart?  

2016-08-10 21_11_31-Start.png


View solution in original post

Helper I
Helper I

What is your end goal? To create a list or to create a specific visual? And if so, what kind of visual?

I am asking, because you do not necessarily need the list in a specific format (such as your excel example) to be able to visualize something. For example, it shouldn't matter whether you have weeks as columne or rows

Thanks @tschmidt87 for your response.


The objective is to design a report in PBI similar to the excel report picture that I put  there.I know that, there is no difference if we put the weeks at left or top although the number of items in "product grouping"  are many and difficult to put all of them on the top and weeks on the left. The issue is that the  people I am working with them they get used to observe the report in the excel format like week on the top and the product grouping at the left for long time.and I was asked If i can design like their excel report.In fact, I receive comments from many people they like excel style report creation.For example,they want the ability to transpose a report table in PBI which is impossible,while you can do in excel easily.


Thank you,


Not applicable

Did you Try a "Matrix" chart?  

2016-08-10 21_11_31-Start.png


Thank you very much @Anonymous.


This is exactly the one I wanted.Great Help.




Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.