Forum Discussion
Rename the Field Parameter
Hi All, I am using a field parameter as a fiter on table column
I would like to have different name for the filter and the table column
For example, table column called "Market" or "Boutique"
in the filter, the selection are "M" and "B"
is it possible?
Thanks
Hi Anonymous ,
First create field parameters for the different names.
Then create inter-table relationship.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v-kkf-msft , this is brilliant and works! Thanks for that
6 Replies
v-kkf-msftCommunity Support
Hi Anonymous ,
First create field parameters for the different names.
Then create inter-table relationship.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v-kkf-msft , this is brilliant and works! Thanks for that
Hi,
When you create a field parameter, that generates a new table with the column name, the measure name and the field order (in my example 'Pareto Field')
If you select the generated table on the data view in power BI, you can edit the name of the Column filed than generates the table, and rename it for whatever you want (In my example 'Downtime Cause' and 'Downtime Type'). That will be reflected on the slicer.
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂Anonymous , but when I change the name of this column in generated table. It will also change both "Filter" & "Column" name
what I hope to do is I could have 2 different set of names for "Filter" & "Column"
Like in the table, it is either "Market" or "Boutique"
But in the Filter, it can only show "M" and "B"
Market Boutique US rd2 UK rd3 Japan rd4 Do you think it is possible?
ivana_tomekovaAdvocate II
You can add manually as many additional columns, as you need to Field parameter table.... and then use those columns in report as you need.... but you have to do it manually in the code and for every single line (each line has to have the same amount of columns... you can then rename column as you like and use it in visuals as needed. Like in this example, for each line, I have added additional text column and rename the column as Type...