No video

Applying Custom Column Ordering for Field Parameters (Measures)

  Рет қаралды 2,381

Havens Consulting

Havens Consulting

Күн бұрын

Пікірлер: 16
@In_a_state
@In_a_state 7 ай бұрын
I would never have thought filtering can impact the order! What a weird PBI quirk! Thanks for sharing.
@HavensConsulting
@HavensConsulting 7 ай бұрын
Right?!
@sakaix7486
@sakaix7486 7 ай бұрын
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.)
@HavensConsulting
@HavensConsulting 7 ай бұрын
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!
@alono2323
@alono2323 7 ай бұрын
Nice trick! It's interesting to check if there are major differences in terms of loading visual time (with and without the visual filter)
@kiterbram
@kiterbram 7 ай бұрын
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.
@HavensConsulting
@HavensConsulting 7 ай бұрын
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.
@LarsSchreiber
@LarsSchreiber 7 ай бұрын
@@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. 😉
@HavensConsulting
@HavensConsulting 7 ай бұрын
@@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.
@LarsSchreiber
@LarsSchreiber 7 ай бұрын
@@HavensConsulting Reid, you're right. I miss read the initial question from @kiterbram. Sorry for the confusion 😉🙏
@LarsSchreiber
@LarsSchreiber 7 ай бұрын
Reid, this is nuts and really helpful. Thanks for sharing ;-)
@HavensConsulting
@HavensConsulting 7 ай бұрын
Glad it was helpful! Stumbled upon this option by accident!
@barttrudeau9237
@barttrudeau9237 7 ай бұрын
That's genius!
@fosiss
@fosiss 4 ай бұрын
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.
@HavensConsulting
@HavensConsulting 4 ай бұрын
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
@fosiss
@fosiss 4 ай бұрын
@@HavensConsulting ah :( thank you for answer
Testing Your Code Using the [DAX] Query View!
10:23
Havens Consulting
Рет қаралды 2 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 101 М.
When you discover a family secret
00:59
im_siowei
Рет қаралды 25 МЛН
❌Разве такое возможно? #story
01:00
Кэри Найс
Рет қаралды 4,1 МЛН
Люблю детей 💕💕💕🥰 #aminkavitaminka #aminokka #miminka #дети
00:24
Аминка Витаминка
Рет қаралды 724 М.
Best Practices for Integrated Notes & Annotations in Power BI
7:02
Havens Consulting
Рет қаралды 2,4 М.
Variance Arrow in a Column/Bar Chart | Power BI Tutorials
6:12
Driven BI Data
Рет қаралды 2,5 М.
The ONE THING that Fields Parameters Were Always Missing
12:30
How to Power BI
Рет қаралды 37 М.
Dynamic Column Headers (with Field Parameters) in Power BI!
7:44
Havens Consulting
Рет қаралды 7 М.
Level Up your Power BI Game with Field Parameters! (with Nikola Ilic)
1:15:04
Havens Consulting
Рет қаралды 2,6 М.
Conditionally Show/Hide Matrix Columns Using Calculation Groups
6:57
Havens Consulting
Рет қаралды 34 М.
11 Power BI Visualization Tricks You Need to Know!
12:20
Goodly
Рет қаралды 19 М.
Using Power BI Field Parameters to add Measure Slicers to a Report
9:38
When you discover a family secret
00:59
im_siowei
Рет қаралды 25 МЛН