0

i have a table i need to design where rows are the actual values as below enter image description here

i tried to use table, the results were as below, which is not what i want:

enter image description here

i tried to use a matrix , i couldnt reach the desired design as well:

enter image description here

can any one have any idea how to do such thing?

Georges Sabbagh
  • 259
  • 3
  • 12
  • 27
  • you'll need to transform the data in your data model. There are options to transpose and unpivot in the query editor. Unpivot the brokerage, commision and other columns into a new column (called measure for example). You will then be able to use that column in a matrix to get the desired results – Alan Schofield Mar 02 '20 at 12:46
  • i think the unpivot will solve my problem, however i cant do it in the current table since i have other visualization attached to this table, also i have many measures created in this table using DAX which they are not visible in edit query and i cannot unpivot them; can you advise what to do next in this case? – Georges Sabbagh Mar 02 '20 at 13:57

1 Answers1

0

i solved it using same concept adopted in the below solution Custom aggregate column in power bi matrix

best regards, Georges

Georges Sabbagh
  • 259
  • 3
  • 12
  • 27