Amazing video! just a quick shout out to both Nikola and Reid, below is the Treatas formula: Sel Value = VAR SelectedValue = SELECTCOLUMNS ( SUMMARIZE ( 'Param Treatas', 'Param Treatas'[Param Treatas], 'Param Treatas'[Param Treatas Fields] ), 'Param Treatas'[Param Treatas] ) RETURN "Selected value from FP is: " & IF ( COUNTROWS ( 'Param Treatas' ) = 1, MAX ( 'Param Treatas'[Param Treatas] ) ) // (COUNTROWS(_SelectedValue),_SelectedValue)
Another great usage of field parameter is to let the user to customize ad hoc a matrix for example, just letting them to select what dimensions to see and in what order. If you multiselect some values inside the field parameter, those dimensions are displayed in the very same order as you click, letting to dinamically change grouping.
Can anybody point me to a video o blog explaining how to retain a hierarchy expanded when changing the selection of the field parameters.. I've read you can, but can't find the how to with details. Thanks
That would be news to both Nikola and I. As neither of us has seen a way around this limitation. It was the topic of the field parameters vs calculation groups video I did a few weeks ago, and that having the hierarchy below a field parameter reset, because the structure of the query changes.
Hey Reid, I just found out that it's possible to create Field Parameters with a Tabular Editor script, so you're not limited to only creating them in Power BI Desktop anymore. GIAC did a video demonstrating the technique back in January, and it's called "Can you use Field Parameters with Direct Lake in Power BI?": th-cam.com/video/Cg6zRhwF-Ro/w-d-xo.html
Amazing video!
just a quick shout out to both Nikola and Reid, below is the Treatas formula:
Sel Value =
VAR SelectedValue =
SELECTCOLUMNS (
SUMMARIZE (
'Param Treatas',
'Param Treatas'[Param Treatas],
'Param Treatas'[Param Treatas Fields]
),
'Param Treatas'[Param Treatas]
)
RETURN
"Selected value from FP is: "
& IF ( COUNTROWS ( 'Param Treatas' ) = 1, MAX ( 'Param Treatas'[Param Treatas] ) )
// (COUNTROWS(_SelectedValue),_SelectedValue)
Another great usage of field parameter is to let the user to customize ad hoc a matrix for example, just letting them to select what dimensions to see and in what order. If you multiselect some values inside the field parameter, those dimensions are displayed in the very same order as you click, letting to dinamically change grouping.
Absolutely, it's essentially what I showcase in this video I released a few weeks back :)
th-cam.com/video/ly63K6i9uxk/w-d-xo.html
Hi Reid. I wasn't clear if the video already exists or not, but I'd love to see you demo the technique you were describing @1:04:11. Cheers
This one one of them, using the field parameter order column as a key :)
th-cam.com/video/KG1S_7BlqAY/w-d-xo.html
Can anybody point me to a video o blog explaining how to retain a hierarchy expanded when changing the selection of the field parameters.. I've read you can, but can't find the how to with details. Thanks
That would be news to both Nikola and I. As neither of us has seen a way around this limitation. It was the topic of the field parameters vs calculation groups video I did a few weeks ago, and that having the hierarchy below a field parameter reset, because the structure of the query changes.
Awesome examples showcasing Field Parameters
Glad you liked it!
I actually used in in a project and worked like MAGIC@@HavensConsulting
I love field parameter more now.thank you
Great to hear!
Could you please me how can use multiple fields parameters with help of data modeling
Hi there! Could you elaborate on your question? What do you mean by "using multiple field parameters"?
Hey Reid, I just found out that it's possible to create Field Parameters with a Tabular Editor script, so you're not limited to only creating them in Power BI Desktop anymore. GIAC did a video demonstrating the technique back in January, and it's called "Can you use Field Parameters with Direct Lake in Power BI?": th-cam.com/video/Cg6zRhwF-Ro/w-d-xo.html
Heck yeah, thanks for that!
Urra!!!!!