The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I want to show data in a matrix but I want the identifiers to be the columns and the values as the rows if that makes sense.
This matrix above is kind of how I want it. But what I really want is with the Dem/FIN to be like side-by-side. What I want to show is like the table i created below.
Dem | FIN |
value | value |
value | value |
value | value |
If I put Dem/FIN into the Columns field, this is what I get and its not what I want.
EDIT 1
The values shown are measures
Any suggetsions?
Solved! Go to Solution.
Hello @Anonymous ,
As seen in you pic, drill down is the best way to represent the data and read it but you want values in rows which is not possible because its a measure and you can not add it directly to a row in matrix. If you want those values only as rows then created a calculated table with all these calculations and use those columns values in the rows.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Can you swith the values in the column section. Have the "Test" on top and right below the Dem/Fin.
you will get something like this
Test | |
Dem | Fin |
Hello @Anonymous ,
As seen in you pic, drill down is the best way to represent the data and read it but you want values in rows which is not possible because its a measure and you can not add it directly to a row in matrix. If you want those values only as rows then created a calculated table with all these calculations and use those columns values in the rows.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!