The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have 13 Order Types which I want to show in a table, but vertically instead of each being their own column.
Each order type has their own column in my tables, so I have 13 seperate measures. I am just using sum formula, though my measures use 3 different tables. Usually when I use matrices it is all from the same table and no problem.
Is there a way to stack measures if they don't all share the same column/table? Maybe without a matrix grid? Below is how I am trying to view my data.
Order Type | Value | % To Total |
Order Type 1 | $985 | 3.3% |
Order Type 2 | $5,487 | 18.3% |
Order Type 3 | $23,512 | 78.4% |
Solved! Go to Solution.
@rlupe Well, you can turn "Show on rows" in a matrix for Values | Options. The other approach would be to unpivot those rows in your data table in Power Query Editor and then you should only require a single measure and could use a table visual.
@rlupe Well, you can turn "Show on rows" in a matrix for Values | Options. The other approach would be to unpivot those rows in your data table in Power Query Editor and then you should only require a single measure and could use a table visual.
Thank you this works! My % To Total column is instead a row under each order type but this fits my needs.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |