Forum Discussion
Design customized reporting
Did you Try a "Matrix" chart?
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,
Regards
Did you Try a "Matrix" chart?
Thank you very much Anonymous.
This is exactly the one I wanted.Great Help.
Regards
Myti