Applying Custom Column Ordering for Field Parameters (Measures)
HTML-код
- Опубликовано: 11 июл 2024
- Learn how to override/replace the default Field Parameter sort order in Power BI. This can be very useful when displaying multiple field parameter measures on columns/rows in table or matrix visuals, or anywhere in a visual where you'd want to show multiple field parameter measures at once. Tune in to learn more!
RELATED CONTENT 🔗
Field Parameters Doc -- learn.microsoft.com/en-us/pow...
BECOME A CHANNEL MEMBER 🎉
-- / @havensconsulting
CHECK OUT OUR MERCH STORE 👕
-- havens-consulting.creator-spr...
LET'S CONNECT! 🧑🏽🤝🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
-- / havensconsulting
VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Courses -- www.havensconsulting.net/onli...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #fieldparameter Наука
I would never have thought filtering can impact the order!
What a weird PBI quirk! Thanks for sharing.
Right?!
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.)
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!
Reid, this is nuts and really helpful. Thanks for sharing ;-)
Glad it was helpful! Stumbled upon this option by accident!
That's genius!
Nice trick! It's interesting to check if there are major differences in terms of loading visual time (with and without the visual filter)
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.
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.
@@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. 😉
@@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.
@@HavensConsulting Reid, you're right. I miss read the initial question from @kiterbram. Sorry for the confusion 😉🙏
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.
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
@@HavensConsulting ah :( thank you for answer