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
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
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": []
}
}
}
},