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,
Property A has 2 distinctcount products - ID1 and ID2. So the answer should be 2. This is same for the other properties as well. How do you get the answer as 1 in each row?