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!
@HavensConsulting to display dynamic 'measure names' I am using a calculated table 'Filter T', the result of a crossjoin between my parameter field table with a date table. This 'Filter T' is related to the parameter table. Doing it this way the custom order does not work, have you come across this? Is there any workaround? P.D: For context, the user is selecting a month and I have done this so instead of showing a measure as 'EoM Sales' or 'Week-1 Sales' it displays the date based on the filter selected (e.g. 'EoM Sales' measure is displayed as '2024-03 Sales')
Hmmm, what's dynamic about the measure names? You can have a field parameter table with the same measure more than once in it, under different names. That's one way I've added logic for the "name" to change :)
@@HavensConsulting I am trying that the name shows the date of reference. So for example, I have a measure that shows sales for the last monday of the selected month, one measure for sales for the previous monday, and one more for two previous mondays. Then for the last monday of the month, I am also looking at other kpis like margin and margin %. But for sales we want to have the last 3 mondays of data, that's why I am not using date as a column in the matrix (because I don't need that showed for previous weeks in the other measures). Example of expected: Currently: Sales CurrentMonday-2weeks | Sales CurrentMonday-1week | Sales CurrentMonday | Margin CurrentMonday | Margin % CurrentMonday Need, user selection September 2024: Sales 09/09/2024 | Sales 16/09/2024 | Sales 23/09/2024 | Margin 23/09/2024 | Margin % 23/09/2024 Need, user selection August 2024: Sales 12/08/2024 | Sales 19/08/2024 | Sales 26/08/2024 | Margin 26/08/2024 | Margin % 26/08/2024
This might be slightly too complex to answer via just UA-cam comments 😅 I’d either recommend posting this to the fabric help forums, where you can upload an example PBIX, otherwise we do offer hourly consulting as well, through our havens consulting website
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
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.
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!
I would never have thought filtering can impact the order!
What a weird PBI quirk! Thanks for sharing.
Right?!
Reid, this is nuts and really helpful. Thanks for sharing ;-)
Glad it was helpful! Stumbled upon this option by accident!
@HavensConsulting to display dynamic 'measure names' I am using a calculated table 'Filter T', the result of a crossjoin between my parameter field table with a date table. This 'Filter T' is related to the parameter table. Doing it this way the custom order does not work, have you come across this? Is there any workaround?
P.D: For context, the user is selecting a month and I have done this so instead of showing a measure as 'EoM Sales' or 'Week-1 Sales' it displays the date based on the filter selected (e.g. 'EoM Sales' measure is displayed as '2024-03 Sales')
Hmmm, what's dynamic about the measure names? You can have a field parameter table with the same measure more than once in it, under different names. That's one way I've added logic for the "name" to change :)
@@HavensConsulting I am trying that the name shows the date of reference. So for example, I have a measure that shows sales for the last monday of the selected month, one measure for sales for the previous monday, and one more for two previous mondays. Then for the last monday of the month, I am also looking at other kpis like margin and margin %. But for sales we want to have the last 3 mondays of data, that's why I am not using date as a column in the matrix (because I don't need that showed for previous weeks in the other measures).
Example of expected:
Currently: Sales CurrentMonday-2weeks | Sales CurrentMonday-1week | Sales CurrentMonday | Margin CurrentMonday | Margin % CurrentMonday
Need, user selection September 2024: Sales 09/09/2024 | Sales 16/09/2024 | Sales 23/09/2024 | Margin 23/09/2024 | Margin % 23/09/2024
Need, user selection August 2024: Sales 12/08/2024 | Sales 19/08/2024 | Sales 26/08/2024 | Margin 26/08/2024 | Margin % 26/08/2024
thanks for your reply by the way :)
This might be slightly too complex to answer via just UA-cam comments 😅
I’d either recommend posting this to the fabric help forums, where you can upload an example PBIX, otherwise we do offer hourly consulting as well, through our havens consulting website
Nice trick! It's interesting to check if there are major differences in terms of loading visual time (with and without the visual filter)
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
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 😉🙏
That's genius!