I would never have thought filtering can impact the order! What a weird PBI quirk! Thanks for sharing.
@HavensConsulting7 ай бұрын
Right?!
@sakaix74867 ай бұрын
Hey there, Thanks for the Video! By the way, this works with a Slicer as well. I often give the USER the possibility to add colums with specific Dimensional Data or specific Measures. So if you have the Customer List, you can add the Adress or Country and add the Measures you want to analyze (Revenue, Number of Orders, etc.)
@HavensConsulting7 ай бұрын
Absolutely, and Field parameters are very versatile that way! All depends on the business requirements, and level of flexibility either the developer, or report user needs!
@alono23237 ай бұрын
Nice trick! It's interesting to check if there are major differences in terms of loading visual time (with and without the visual filter)
@kiterbram7 ай бұрын
Great video! The one thing I am still unable to do is to keep the sort order by amount/value in a visual, after you switched between field parameter values. It always changes back unfortunately.
@HavensConsulting7 ай бұрын
Yeah since the visual query completely changes when you do that, there's no way for the visual to cache any sort order. Hopefully a fix in the future, but that's just a limitation of field parameters in general sadly.
@LarsSchreiber7 ай бұрын
@@HavensConsulting actually there is a way by using an additional measure, that sorts dependent on the chosen parameter. I have a video in my pipeline on my own channel regarding this topic. 😉
@HavensConsulting7 ай бұрын
@@LarsSchreiber I've used that to sort the values IN a column before, and it's great!. But I'm not sorting the columns themselves, there isn't a sort option for that to my understanding. As that is driven by the "order" the fields are placed in the matrix row or column wells. That's what this video is modifying, is that order they show, not the actual sort value within them.
@LarsSchreiber7 ай бұрын
@@HavensConsulting Reid, you're right. I miss read the initial question from @kiterbram. Sorry for the confusion 😉🙏
@LarsSchreiber7 ай бұрын
Reid, this is nuts and really helpful. Thanks for sharing ;-)
@HavensConsulting7 ай бұрын
Glad it was helpful! Stumbled upon this option by accident!
@barttrudeau92377 ай бұрын
That's genius!
@fosiss4 ай бұрын
Is there a way to block column sort order? Eg. I have a slicer with field parameters for Actuals (CY), Budget, PY, YTD_CY etc. The measures are shown in the column in order of choosing them in the slicer, but I would like to show them always in specified order.
@HavensConsulting4 ай бұрын
With a field parameter they'll always enter in the order you click, left to right. I don't think there is a way to click in any order then have them still sort seperately