Measures on Matrix

[topazz11]

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!

[lc_finance]

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]

@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.

[v-lid-msft · Accepted solution]

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]

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