Forum Discussion
Create Slicer by column names
I need some help with this scenario...
I have PowerBi report which its source is Direct Query to a SQL Database where sensors data are stored. The generated columns have the following names: INV1_X1, INV1_X2, INV1_X3, INV2_X1, INV2_X2, INV2_X3, INV3_X1, INV3_X2, INV3_X3. I want to have a slicer that is generated by the first four letters of the above columns so that the user can click the label "INV1" and see the data of INV1 device and so on.
Is it possible?
Thanks in advance
Hi, Anonymous
Field parameter is a preview feature.
Let report readers use field parameters to change visuals (preview)
Please make sure you have downloaded the latest version of PowerBI Desktop and enable 'Field parameters' in Options and settings.
Best Regards,
Community Support Team _ Eason
3 Replies
- amitchandak
Super User
Anonymous , Check if Field parameters can help
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllEYou can rename display name , once field parameter table is displayed
Thanks for the immediate answer, but before further searching I don't have the field parameter in the "New Parameter" option in "Modelling" tab.
- v-easonf-msft
Community Support
Hi, Anonymous
Field parameter is a preview feature.
Let report readers use field parameters to change visuals (preview)
Please make sure you have downloaded the latest version of PowerBI Desktop and enable 'Field parameters' in Options and settings.
Best Regards,
Community Support Team _ Eason
