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.
Hi Guys,
We used to build matrix report in below structure in Excel or other reporting platform. However, when it comes to using Measures in Power BI, I have not found a way to stack them in such structure yet.
Below is a workaround structure in Power BI. But, as many Power BI folks are asking the same question. I wanted to throw this question out there to see if anyone else has a solution. How can we stack measures in Power BI as presented above?
Looking forward to your solutions!
Solved! Go to Solution.
Hi Chrissie
Please consider this solution.
I am an unpaid Power BI volunteer so please click the thumbs up if you like me trying to help you and the solved button if I fix your problem.
Create the followind 2 dynamic measures.
Then create a matrix with rows = Zone and Type,
leave Columns = blank
and Values = Score 1 and Score 2
Hi Chrissie
Please consider this solution.
I am an unpaid Power BI volunteer so please click the thumbs up if you like me trying to help you and the solved button if I fix your problem.
Create the followind 2 dynamic measures.
Then create a matrix with rows = Zone and Type,
leave Columns = blank
and Values = Score 1 and Score 2
It looks like a possible solution. I will test to see if it works once I get a chance. Thank you very much!
I am an unpaid power Bi volunteer. Please click solved to accept the solution so we get kudos. If your problem has expanded or changed then set this one to solved and raise a new ticket, because this solution does seem to answer the original question. Many thanks.
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |