<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Power BI Custom visual - Table in Custom Visuals Development Discussion</title>
    <link>https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-Custom-visual-Table/m-p/4022758#M10095</link>
    <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;TS2322: Type '{ slices: undefined[]; }' is not assignable to type 'FormattingGroup | FormattingGroupPlaceholder'.&lt;BR /&gt;Type '{ slices: undefined[]; }' is missing the following properties from type 'FormattingGroup': uid, displayName&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;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) =&amp;gt; {
            row.forEach((cell, cellIndex) =&amp;gt; {
                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;
    }&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 03 Jul 2024 11:17:16 GMT</pubDate>
    <dc:creator>max14</dc:creator>
    <dc:date>2024-07-03T11:17:16Z</dc:date>
    <item>
      <title>Power BI Custom visual - Table</title>
      <link>https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-Custom-visual-Table/m-p/4022758#M10095</link>
      <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;TS2322: Type '{ slices: undefined[]; }' is not assignable to type 'FormattingGroup | FormattingGroupPlaceholder'.&lt;BR /&gt;Type '{ slices: undefined[]; }' is missing the following properties from type 'FormattingGroup': uid, displayName&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;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) =&amp;gt; {
            row.forEach((cell, cellIndex) =&amp;gt; {
                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;
    }&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 03 Jul 2024 11:17:16 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-Custom-visual-Table/m-p/4022758#M10095</guid>
      <dc:creator>max14</dc:creator>
      <dc:date>2024-07-03T11:17:16Z</dc:date>
    </item>
  </channel>
</rss>

