topic Re: Custom Visual, when I add table binding, the custom formatting disappears. in Developer

Custom Visual, when I add table binding, the custom formatting disappears.

Anonymous — Wed, 13 Mar 2019 17:23:56 GMT

I use API 2.3.0

I created table bind

{
    "dataRoles": [
        {
            "displayName": "Category",
            "name": "Category",
            "kind": "GroupingOrMeasure"
        },
        {
            "displayName": "Value1",
            "name": "Value1",
            "kind": "GroupingOrMeasure"
        },
        {
            "displayName": "Value2",
            "name": "Value2",
            "kind": "GroupingOrMeasure"
        }
    ],
    "objects": {
        "category": {
            "displayName": "Category ",
            "properties": {
                "show": {
                    "displayName": "Turn on/off",
                    "type": {
                        "bool": true
                    }
                },    
                "fontColor": {
                    "displayName": "Font Color",
                    "description": "Select font color",
                    "type": {
                        "fill": {
                            "solid": {
                                "color": true
                            }
                        }
                    }
                }
            }
        }       
    },
    "dataViewMappings": [
        {
            "table": {
                "rows": {
                    "select": [
                        {
                            "for": {
                                "in": "Category"
                            }
                        },                
                        {
                            "for": {
                                "in": "Value1"
                            }
                        },
                        {
                            "for": {
                                "in": "Value2"
                            }
                        }
                    ],
                    "dataReductionAlgorithm": {
                        "sample": {
                            "count": 2000
                        }
                    }
                }
            }
        }
    ]
}

When I add custom visual to the board, I see custom formatting. But when select some field, custom formatting disappears.

The general format is always available.

When I bind via category, everything works correctly. But I need to work with table now.

Function enumerateObjectInstances has default code

 const settings: VisualSettings = this.visualSettings || 
                                         VisualSettings.getDefault() as VisualSettings;
        var visualObjects: VisualObjectInstanceEnumerationObject = <VisualObjectInstanceEnumerationObject> VisualSettings.enumerateObjectInstances(settings, options);
        return visualObjects;

In update method I add

let dataView = options.dataViews[0] || {} as powerbi.DataView;

this.visualSettings = VisualSettings.parse<VisualSettings>(dataView);

What I miss?

Also what is the best way to parse data bind?

I have noticed that sometimes metadata.object is not displayed, why?

Re: Custom Visual, when I add table binding, the custom formatting disappears.

v-evelk — Thu, 14 Mar 2019 12:26:50 GMT

Hello,

It is necessary to analyze the source code to make some suggestion. Could you please share the repo link or send files to pbicvsupport@microsoft.com for analysis?

Thanks!

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: Custom Visual, when I add table binding, the custom formatting disappears.

dm-p — Fri, 15 Mar 2019 00:09:57 GMT

I can't help with the majority of what you're asking, but regarding your question about metadata.objects not always being present - in my experience, this is only populated if a property is different to its default value, i.e. modified by the end-user. If your visual has not have any properties modified from the defaults then this will be empty.

The framework will assume the default values (typically specified in your settings.ts) if this is not present for any objects defined. The following code in your post is handling that part:

const settings: VisualSettings = this.visualSettings || 
                                         VisualSettings.getDefault() as VisualSettings;

Re: Custom Visual, when I add table binding, the custom formatting disappears.

Anonymous — Fri, 15 Mar 2019 09:59:27 GMT

Thanks, I've noticed it duration same time.

Re: Custom Visual, when I add table binding, the custom formatting disappears.

Anonymous — Fri, 15 Mar 2019 10:03:22 GMT

I found the problem, It was the cache issues.

Also, do you know where I can find full documentation about capabilities.json?

Re: Custom Visual, when I add table binding, the custom formatting disappears.

v-evelk — Fri, 15 Mar 2019 10:34:28 GMT

Hello,

You should check the following documentation pages:

https://microsoft.github.io/PowerBI-visuals/docs/concepts/capabilities/

https://microsoft.github.io/PowerBI-visuals/docs/concepts/dataviewmappings/

https://microsoft.github.io/PowerBI-visuals/docs/concepts/objects-and-properties/

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: Custom Visual, when I add table binding, the custom formatting disappears.

Anonymous — Fri, 15 Mar 2019 10:37:35 GMT

Ok, thank you.