Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Regards
Mehdi
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |