Forum Discussion
Pivot Formatting
Hello I have this table: Product Property Min Max ID1 A 1 3 ID1 B 2 4 ID1 C 3 6 ID2 A 4 5 ID2 B 1 2 ID2 C 2 4 And I need to create this pivot: ...
Hi Anonymous ,
In Power BI matrix visual, you will need to put both [Product] and [Property] in Rows field.
And the result would be like below. Otherwise the values will be aggregated.
Hi,
Drag Property, Min and Max to a Table visual and write this measure
Measure = distinctcount(Data[Property])
Hope this helps.
Ashish_Mathur thanks but I need this in a matrix/pivot visual, sorry if it wasn't clear
No where in your previous posts did you mention that you wanted the result in a card visual. Anyways, now i am confused about what you want. Show the exact result you want.