Forum Discussion
Field Parameter in Matrix not sorting by column
Hi isjulia
The fields parameter is a kind of "measures list", so there is no option to sort them not in the order they selected.
(because sorting options are available only for rows/columns, not measures)
If the sort issue is critical you can use a matrix with dynamic measure / calculated groups instead.
The pbix with an example of a dynamic measure is attached.If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
I think in this case the dynamic matrix / calculated groups are the only possible alternatives including creating measures.
And yep it doesn't work because even if every parameter is from a column ...in the visual table is like a "value"...If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Interestingly the desired behaviour works in Power BI Desktop when you're developing the report, but when published (and users are using it online) it changes to adding columns onto the end as and when they're selected by the user...
So it doesn't seem like an issue with PowerBI itself unable to do it, just the behaviour of the online version.