Forum Discussion
ASI_12
7 months agoNew Member
BUG: Matrix + Field Parameters + Groups → Order not respected
I am experiencing an unexpected behavior when using Field Parameters inside a Matrix visual in Power BI Desktop. I created a Field Parameter containing multiple fields organized into groups. When the...
HarishKM
7 months agoSuper User
ASI_12 Hello,
- Recreate the parameter without groups (single group). Set a stable [Order] and ensure [Name] is “Sort by” that [Order]. You’ll get a predictable order (but still not selection order).
- If users must dictate the exact order: Use “slots.”
- Create N field parameters (Param_1 … Param_N) each containing the same fields.
- Place Param_1, Param_2, … in the Matrix Columns left to right.
- Add N slicers (one per slot). Users pick A in Param_1, D in Param_2, etc., yielding A, D, C, B.
- Note: Scales poorly with 150 columns; only feasible for a small N.
- Offer fixed ordering choices instead of arbitrary order:
- Create duplicate parameter tables with different [Order] (e.g., business priority, alphabetical, recent usage).
- Switch which parameter the Matrix uses with a separate “view selector” (bookmarks or a secondary field parameter).
- If you need free-form, scalable ordering: Use a custom visual (e.g., Deneb/Vega-Lite) that can encode order by selection rank or an input index. Native visuals don’t support per-user, per-session selection-order sorting.
Thanks
Haish K
If I resolve your issue. Kindly give kudos to this post and accept it as a solution so other can refer this