Forum Discussion

Icon for Helper III rank

Helper III

6 years ago

Solved

Measures on Matrix

Hi, I was wondering if this is possible.

I have a matrix with measures on rows and year on columns.

Value1, Value2, Value3 should go to rows but value 4 need to go to values in the Matrix field.

Seems like it doesnt work, but in Excel it is possible becuase i can convert value 1, 2, 3 as general/custom.

Or Can I convert the measures to text/general like Excel pivot table?

Thanks in advance!

v-lid-msft
6 years ago
Hi topazz11 ,

We can not put measure into the Row Field of Matrix visual, if you want to show it, we can create a calculated table to meet your requirement.

Table = ADDCOLUMNS(GROUPBY('Table1',Table1[item]),"Value1",[Value1],"Value2",[Value2])

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

lc_finance
Solution Sage
6 years ago
Hi topazz11 ,

could you show an example of the initial table (the table you load into Power BI) and then an example of what you want the matrix to look like based on the same table?

Regards

LC
- topazz11
  Helper III
  6 years ago
  lc_finance
  here is the example; I am trying to add 'value1' and 'value2' from value123 table between sts and date in the Matrix table. (Adding it to rows)
  pbix
  
  Thank you for your help.
  - lc_finance
    Solution Sage
    6 years ago
    Hi topazz11 ,
    
    i am not sure it's possible. If you want to convert your measure to string you can add &"" to it.
    
    Value1 = CALCULATE( SUM(value123[no])&"", Year(value123[date])=2019 )
    For example, this is the new measure that is now recognized as a string.
    
    Sorry, I wouldn't know how to help you further,
    
    LC