Forum Discussion
power bi matrix - support 2 data types in same measure
Super UserHi, can you tell us a bit more about the requirement here? because as far as I can read you don't need a matrix you just need a table. The main difference between them is that the matrix will aggregate the values by columns or rows. The table will let you have the option of "Don't Summarize" in order to add columns with text or urls.
Hope this helps, let us know a bit more in case this doesn't resolve the issue.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for your response.
I have to use matrix as my data is key value (meaning not preminenet number of columns). we were asked to allow users to filter columns (so we use column name in the pivot column and the value in values and use column name as filter as well.
Assum it has to be pivot - do you have any idea on resolution? thanks!!
Example:
Column name Column value
Type A
Type B
Age 1
Age 2
Circle picture1
Circle picture2
- ibarrau
Ok. About two values in one measure rendering image, I don't think it's possible. You may be able to concatenate the max of text of url and type in one measure but not rendering image. You should use two measures if you want the image url to show the picture in the matrix (using a measure with max and categorizing it as image url, then in format activate "url icon" for values)
Hope this helps.