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.
I am new to PBI Report builder and I am trying to build a report where tables are set up in a way that each row is a measure and the columns slice each measure by a dimension, for example each column would be a different year. Is it possible to build this in PBI report builder? How is it accomplished?
Try to achieve it with Matrix table
- If you are using power bi, create a matrix visual. Under format goto "Values" and you will see the option "Show on rows" , it is off by default, make it "on" and your measures will appear in rows , and put your year in "Columns" to get your desired results.
Proud to be a Super User!
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 |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |