Forum Discussion
Field Parameter Column does not drill by down correctly in matrix or table visual
Hello!
- I created a field parameter with the measures Sales Amount, Number of Orders, and Number of Customers.
- I created a new group within the field parameter table, and grouped Sales Amount under "Sales", Number of Orders under "Orders", and Number of Customers under "Customer".
- Added field parameter measures as the Values in the Matrix Visual
- Added field parameter group as the Rows in the Matrix Visual
Expected Result
The matrix visual is drilled down on rows, showing the measure Sales Amount under the group "Sales", Number of Orders under "Orders", and Number of Customers under "Customer".
Actual Result:
All measures show up under all groups. For example, Sales Amount, Number of Orders, and Number of Customers show up 9 times or 3 times under each group. It seems like the parameter group is not relating correctly to the parameter measures. I don't understand why this behavior, because when I use the groups in a slicer it works perfectly.
2 Replies
- AnonymousNot applicable
Hi blaj ,
Based on the description, Power BI field parameter don’t inherently understand the group hierarchy.
You can view the following document to learn more information.
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- blajHelper I
Anonymous so what would be a solution for grouping measures?