Forum Discussion
Field Parameters - Dynamic Visual Title
Thank you,
My setup seems to be a bit different.
When I use the field parameter wizard it creates a calculated table with 3 columns:
xP_Param
xP_Param Fields
xP_Param OrderI can use the Fields or Order columns but get the composite key error if trying to use the XP_Parm column which has the formated text name I want to use as the visual title.
I tried adding .Key0 as in the link you provided but encountered a different error.
Is there something I'm missing?
Edit, I found a work around using my switch syntax but its a bit of extra work to retype the titles and not re-use them from the calculated table columnxP_param1 Title = SWITCH ( SELECTEDVALUE ( xP_Param[xP_Param Order] ), 0, "Title 1", 1, "Title 2", 2, "Title 3", 3, "Title 4", 4, "Title 5" )Second edit, SQLBI just posted a great article describing this issue and how to solve it - https://www.sqlbi.com/blog/marco/2022/06/11/using-selectedvalue-with-fields-parameters-in-power-bi/
Hi itchyeyeballs ,
For this error, you can refer to the following link:
For the title, you can turn it into Text format:
xP_Param_Title =
var _select=SELECTEDVALUE ( xP_Param[xP_Param Order] )
return
SWITCH (
TRUE()
,
_select= 0, [MeasureA],
_select= 1, [MeasureB],
_select= 2, [MeasureC]
)Flag =
FORMAT('xP_Param'[xP_Param_Title],"0")Format – Title – Title text – fx.
Enter the Title text – Title interface. Select [Flag].
Result:
If you need pbix, please click here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thats a good solution. But how can i get rid of the hometable name of the title. In your case xP_Param.
How the measure code would be looking?