Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
How do you implement the FieldPicker formatting setting in a project? I am having severe issues with it, and I can't find a single example anywhere of an implementation of it (in code).
This is my current set-up. I have tried to make it as basic as possible but the only value I get when implemented and adding a data field is "[Object object]" (as an actual string value).
Capabilities:
"DropdownDataFields":{
"type": {
"text": true
}
}
(note, I have tried both "numeric", "integer", "text", "bool" and "enumeration: []")
Setting:
public dataFields: formattingSettings.FieldPicker = new formattingSettings.FieldPicker({
validators: {},
name:"DropdownDataFields",
value: []
});
Thanks!
Hello @MartinRKrupa, while I had no luck figuring out how to do it (if it's even possible), I did find a workaround. VisualEnumerationInstanceKinds allows users to add measures as values for settings in PowerBI Custom Visuals via Conditional Formatting.
It's not perfect, but it might be possible for you to achieve something similar.
public fontColor: formattingSettings.ColorPicker = new formattingSettings.ColorPicker({
name: 'fontColor',
displayName: 'Text color',
instanceKind: VisualEnumerationInstanceKinds.ConstantOrRule,
value: {
value: ''
}
});
The above example is a simple color picker example. Using the VisualEnumerationInstanceKinds.ConstantOrRule, users get the f(x) icon next to the setting and can set it to a measure (although in this case the output should be a hex color code). With this, users can easily define their own dynamic values for color style, e.g. for a "dark mode".
Most formattingSettings I have seen allow the instanceKind property.
Hi, I'm having the same issue. Anyone's figured out /found any documentation on how to use the FieldPicker?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.