Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I am trying to create custom Table visual. While adding the conditional formating option I am getting error. How do I rectify it. Is there sample code available for custom Table visual. I checked the documentation but not getting much info.
TS2322: Type '{ slices: undefined[]; }' is not assignable to type 'FormattingGroup | FormattingGroupPlaceholder'.
Type '{ slices: undefined[]; }' is missing the following properties from type 'FormattingGroup': uid, displayName
public getFormattingModel(): powerbi.visuals.FormattingModel {
const formattingModel: powerbi.visuals.FormattingModel = {
cards: []
};
const formattingCard: powerbi.visuals.FormattingCard = {
displayName: "Cell Elements",
uid: "cellElementsCard",
description: "Customize the cell elements",
groups: [
{
slices: []
}
]
};
const tableData = this.dataView.table.rows;
const columns = this.dataView.table.columns;
tableData.forEach((row, rowIndex) => {
row.forEach((cell, cellIndex) => {
const columnName = columns[cellIndex].displayName;
const colorSetting = this.tableSettings.cellElements.backgroundColor;
const backgroundColorSlice: powerbi.visuals.FormattingSlice = {
displayName: `${columnName} Background Color`,
uid: `backgroundColor_${rowIndex}_${cellIndex}`,
control: {
type: powerbi.visuals.FormattingComponent.ColorPicker,
properties: {
descriptor: {
objectName: "cellElements",
propertyName: "backgroundColor",
selector: dataViewWildcard.createDataViewWildcardSelector(dataViewWildcard.DataViewWildcardMatchingOption.InstancesAndTotals), // Corrected option
altConstantValueSelector: null,
instanceKind: powerbi.VisualEnumerationInstanceKinds.ConstantOrRule
},
value: { value: colorSetting }
}
}
};
const fontColorSlice: powerbi.visuals.FormattingSlice = {
displayName: `${columnName} Font Color`,
uid: `fontColor_${rowIndex}_${cellIndex}`,
control: {
type: powerbi.visuals.FormattingComponent.ColorPicker,
properties: {
descriptor: {
objectName: "cellElements",
propertyName: "fontColor",
selector: dataViewWildcard.createDataViewWildcardSelector(dataViewWildcard.DataViewWildcardMatchingOption.InstancesAndTotals), // Corrected option
altConstantValueSelector: null,
instanceKind: powerbi.VisualEnumerationInstanceKinds.ConstantOrRule
},
value: { value: this.tableSettings.cellElements.fontColor }
}
}
};
formattingCard.groups[0].slices.push(backgroundColorSlice, fontColorSlice);
});
});
formattingModel.cards.push(formattingCard);
return formattingModel;
}
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.