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.
Hello,
I have excel data with two factories, can Power BI matrix display the output as second photo?
How to drag the field in Power BI?
Original Excel data:
Desired out in Power BI matrix:
Solved! Go to Solution.
@pang22
Basically, you need to show your measures on the row, to achieve that, turnon "Switch Values to Rows"
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @pang22 ,
Hi
Add Factory to Row, Date to column and Order and Capacity to Values. In Visual pane, disable stepped layout and turn on switch values to rows. Please screenshots below.
Proud to be a Super User!
@pang22
Basically, you need to show your measures on the row, to achieve that, turnon "Switch Values to Rows"
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |