Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Property | Min | Max | Distinct Count of Product |
A | 1 | 3 | 1 |
A | 4 | 5 | 1 |
B | 1 | 2 | 1 |
B | 2 | 4 | 1 |
C | 2 | 4 | 1 |
C | 3 | 6 | 1 |
Any idea how to format the above?
Thanks!
Solved! Go to Solution.
Hi @UsePowerBI ,
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 @UsePowerBI ,
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.
Changing the layout form of a PivotTable
To make substantial layout changes to a PivotTable or its various fields, you can use one of three forms:
Compact form displays items from different row area fields in one column and uses indentation to distinguish between the items from different fields. Row labels take up less space in compact form, which leaves more room for numeric data. Expand and Collapse buttons are displayed so that you can display or hide details in compact form. Compact form is saves space and makes the PivotTable more readable and is therefore specified as the default layout form for PivotTables.
PivotTable in compact form
Tabular form displays one column per field and provides space for field headers.
PivotTable in tabular form
Outline form is similar to tabular form but it can display subtotals at the top of every group because items in the next column are displayed one row below the current item.
Regards,
Rachel Gomez
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |