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! I need your expert guidance, please. I am working on a dataset to get the volume percentage of each size, per quartile. I also want to create a table visual in powerBI. Here is what the data and expected output looks like.
Thank you in advance! ❤️
PS:
I've used the below formula but im getting the same % results for all sizes for Q1-Q4 . 😞
Solved! Go to Solution.
Hi @jonalyncas
Step 1: Please go to Power Query and Unpivot all your data
Step 2: Go back to your reporting tab and create a matrix as per such
Step 3: Click on dropdown on count of value > Show Value As > Percent of Row Total
BR
Hey @Anonymous , thank you so much. First time I leaned about unpivot. Very helpful. And thank you for helping out with the steps. You're a Gem. 🙂
Hi @jonalyncas
Step 1: Please go to Power Query and Unpivot all your data
Step 2: Go back to your reporting tab and create a matrix as per such
Step 3: Click on dropdown on count of value > Show Value As > Percent of Row Total
BR
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 |
---|---|
99 | |
98 | |
76 | |
66 | |
59 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |