Cannot successfully implement color picker on visual using table mapping

FR5702 To parse color properly you should specify a selector for each item of finalData.

this.uniqueColorRetrieve(this.finaldata).forEach(d => {
                        objectEnumeration.push({
                            objectName: objectName,
                            displayName: d.name,
                            properties : {
                                fill: d.color
                            },
                            selector: d.identity.getSelector(),
                        });
                    });

You should also parse color for row by using something like this:

row.objects[0] // It will contain properties. Please use console.log to figure out its structure.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]

To support such grouping you should start using categorical data mapping instead of table mapping.

Categorical mapping supports "group by" option.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]

Correct. You should have numeric data column in a data set. Such column will allow grouping that required to implement desired behavior.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]

Hi v-viig,

Thanks for your tips, I have a better understanding of how it works.

But I still have a problem...

To recap, if it's confusing for you, here what I'm doing:

1) I take all my datapoints (with their color define by  

color: this.host.colorPalette.getColor(<string>columns["Dim1"]).value,

and identity define by

this.getSelectionIds(dataView, this.host)

with

private  getSelectionIds( dataView: DataView, host: IVisualHost): powerbi.visuals.ISelectionId[] {
            const queryName: string = dataView.table.columns[0].queryName;

            return dataView.table.identity.map((identity: DataViewScopeIdentity) => {
                const categoryColumn: DataViewCategoryColumn = {
                    source: {
                        queryName,
                        displayName: null
                    },
                    values: null,
                    identity: [identity]
                };

                return host.createSelectionIdBuilder()
                    .withCategory(categoryColumn, 0)
                    .withMeasure(queryName)
                    .createSelectionId();
            });
        }

)

2) I group them by my four dimensions = I create X groups

3) I represent them on my chart = 1 point per group

The result is this one :

And I want to be able to change the color of my groups depending on 1 Dimension ( Dim1).

As it needs the identity to bound my object with my data, I use the identity from my datapoints.

But how can I use all the identities of the datapoints having the same Dim1 value ? Because if I use an identity from my dataPoints, it'll not have any effect as the other dataPoints of his group won't be bound to my object and therefore won't change.

I tried to define an identity for each of my groups with :

this.host.createSelectionIdBuilder().withMeasure(list[i].Dim1).createSelectionId()

but it didn't change anything.

And when I change my Datapoints' identites by these group identities, my chart broke while my data are fine (I checked in my console).

My question is : How can I change my DataPoints' identities to group identities without breaking my chart ? Or is there an other solution ?

Thank you for your help, I really need it :)

Thanks v-viig I get the logic but I don't know how it can be apply to my case as I don't have any value data (all my data are text format).

How can I go from

"table": {
                "rows": {
                    "select": [
                        {"for": {
                            "in": "Details"
                        }},
                        {"for": {
                            "in": "Yaxis"
                        }},
                        {"for": {
                            "in": "Xaxis"
                        }},
                        {"for": {
                            "in": "Dim2"
                        }},
                        {"for": {
                            "in": "Dim1"
                        }}
                    ]
                },
                "conditions": [{
                    "Details":{
                        "max": 1
                    },
                    "Yaxis":{
                        "max": 1
                    },
                    "Xaxis":{
                        "max": 1
                    },
                    "Dim1":{
                        "max": 1
                    },
                    "Dim2":{
                        "max": 1
                    }
                }]
            }

 to something similar to the examples 2 or 3

Don't have numbers? If so, there's no way to impelement desired behavior w/o using numbers.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]

Yes, I transform my data from text to numeric in my code, but what I get from my DataSource are all text data.

There no way to have this behaviour without numbers directly in my DataSource ? Or do I have to make all the transformation when I create my ViewModel/DataPoints in order to enable my color picker ?