Forum Discussion

topazz11's avatar
topazz11
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....
Need Help
  • v-lid-msft's avatar
    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.

lc_finance's avatar
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's avatar
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's avatar
    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

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    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.