Hi All,
I recently migrated from enumerateObjectInstances to getFormattingModel() for defining custom formatting options in my Power BI custom visual. Everything is working fine, but I am facing an issue with conditional formatting:
- The conditional formatting options are not working as expected.
- The "fx" option (used for dynamic/conditional formatting) is not visible in the formatting panel where it should be.
Thanks in advance
Below is the relevant part of my code:
public getFormattingModel(): powerbi.visuals.FormattingModel {
// Ensure settings are initialized or use default settings
this.visualSettings = this.visualSettings || <VisualSettings>VisualSettings.getDefault();
// Create formatting cards based on the visualSettingsConfig
const cards: powerbi.visuals.FormattingCard[] = Object.keys(visualSettingsConfig).map((objectName) => {
const config = visualSettingsConfig[objectName];
const slices: any[] = Object.keys(config.properties).map((prop) => {
const controlType = this.getControlType(prop);
const isColorPicker = controlType === powerbi.visuals.FormattingComponent.ColorPicker;
// Fetch propertyInstanceKind for conditional formatting
const propertyInstanceKind = config.properties[prop].propertyInstanceKind;
const descriptor = {
objectName,
propertyName: prop,
...(propertyInstanceKind && { propertyInstanceKind }), // Include propertyInstanceKind if applicable
};
const control: any = {
type: controlType,
properties: {
descriptor,
value: isColorPicker
? { value: this.visualSettings[objectName][prop] }
: this.visualSettings[objectName][prop],
},
};
return {
uid: `${objectName}_${prop}_slice`,
displayName: config.properties[prop].displayName,
control,
};
});
return {
displayName: config.displayName || objectName.charAt(0).toUpperCase() + objectName.slice(1),
uid: `${objectName}_card`,
groups: [
{
displayName: "",
uid: `${objectName}_single_group`,
slices,
},
],
};
}).filter((card) => card !== null);
return { cards };
}
// Helper method to get the control type based on property type
private getControlType(propertyName: string): powerbi.visuals.FormattingComponent {
if (/\b(color|fill|solid|plan|gridfill)\b/i.test(propertyName)) {
return powerbi.visuals.FormattingComponent.ColorPicker;
} else if (/show|toggle/i.test(propertyName)) {
return powerbi.visuals.FormattingComponent.ToggleSwitch;
} else if (/size|width|height|fontsize|padding/i.test(propertyName)) {
return powerbi.visuals.FormattingComponent.NumUpDown;
} else if (/direction|secdirection/i.test(propertyName)) {
return powerbi.visuals.FormattingComponent.ConditionalFormattingControl; // Trying to enable conditional formatting
} else {
return powerbi.visuals.FormattingComponent.TextInput;
}
}
