Forum Discussion
Dynamically define dropdown list in custom Power BI visual
- 2 years ago
These posts concerned replicating the features in core visuals, where properties can be assigned to selectors (e.g., the legend or measure values), known internally as 'containers.' This didn't fully work but has since been fixed. For the older formatting pane implementations, Power BI would generate them for you. It would work off the data view rather than the approach you're using (which I assume would use another persisted property).
I have an example of dynamic dropdown population in Deneb, which you can find here. It may help you confirm if you're on the right track. I guess you'd need to somehow pass in the list of values from your other property, and this could conceivably work.
Hopefully some of this is useful for you. Good luck!
Daniel
dm-p I saw some entries from 2020 when you were trying to do the same thing (I believe). Did you manage to find a solution using the latest API?
- dm-p2 years agoSuper User
These posts concerned replicating the features in core visuals, where properties can be assigned to selectors (e.g., the legend or measure values), known internally as 'containers.' This didn't fully work but has since been fixed. For the older formatting pane implementations, Power BI would generate them for you. It would work off the data view rather than the approach you're using (which I assume would use another persisted property).
I have an example of dynamic dropdown population in Deneb, which you can find here. It may help you confirm if you're on the right track. I guess you'd need to somehow pass in the list of values from your other property, and this could conceivably work.
Hopefully some of this is useful for you. Good luck!
Daniel
- Covid191 year agoFrequent Visitor
I confirm, I checked in power bi, and power bi desktop, the contents of the dropdown change dynamically, the contents can be loaded from other methods of other classes, which made my life much easier.
barChartSettingsModel.ts
import powerbiVisualsApi from "powerbi-visuals-api"; import { formattingSettings } from "powerbi-visuals-utils-formattingmodel"; class positionSelect { private po : powerbi.IEnumMember[]; setPosition():powerbi.IEnumMember[]{ this.po = []; let min = Math.ceil(1); let max = Math.floor(10); let nm = Math.floor(Math.random() * (max - min + 1)) + min; for (let i = 1; i<= nm ; i++){ let curPositionOptions: powerbi.IEnumMember = {value : i, displayName : i.toString()}; this.po.push(curPositionOptions); } return this.po } } let positionOptions : powerbi.IEnumMember[]; class LabelsCardSetting extends formattingSettings.SimpleCard { name: string = "labels"; // same as capabilities object name displayName: string = "Labels"; public option: formattingSettings.ItemDropdown; public setOption():formattingSettings.ItemDropdown { positionOptions = new positionSelect().setPosition(); this.option = new formattingSettings.ItemDropdown({ name: "option", // same as capabilities property name displayName: "Option", items: positionOptions, value: positionOptions[0] }); return this.option } public slices: formattingSettings.Slice[] = [ this.setOption()]; } /** * BarChart formatting settings model class */ export class BarChartSettingsModel extends Model { labels = new LabelsCardSetting(); cards: Card[] = [this.labels]; }capabilities.json
"labels": { "properties": { "option": { "type": { "enumeration": [] } } } },