Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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
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)
Thank you for your help.
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.
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
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |