Forum Discussion

aristogeiton's avatar
aristogeiton
Frequent Visitor
8 years ago
Solved

Cannot successfully implement color picker on visual using table mapping

I am using the table type dataViewMapping.   I'm trying to store and retrieve colors, however colors don't save successfully.   I'm creating my selection Ids using the code from #77:   private ...
Need Help
  • v-viig's avatar
    v-viig
    8 years ago

    Please this code snippet below to fix the issues with color picker:

     

            private static 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();
            });
        }

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

  • FR5702's avatar
    FR5702
    8 years ago

    Alright thank you !

     

    For those with the same situation, I find a workaround.

     

    You should use

    d3.scale.ordinal().domain(data.map(d => d.dimension).range(color_library)

    With color_library an array of color your users can pick ( I take 10  for my chart but you can use 3 or 20...).

     

     

    Not the best solution, I have to admit but it works for now until I find something else :)

aristogeiton's avatar
aristogeiton
Frequent Visitor
8 years ago

Hi Igant,

 

I sent this through last week; I hope you received it.

 

Could the problem be that I am running getSelectionIds for each VisualUpdateType = 2? I get a type 2 update whenever I change one of the selections. Is running getSelectionIds() at that time overwriting my selections?

v-viig's avatar
v-viig
Community Champion
8 years ago

I didn't receive the code. Could you please share tocde by using One Drive?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

  • v-viig's avatar
    v-viig
    Community Champion
    8 years ago

    Please this code snippet below to fix the issues with color picker:

     

            private static 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();
            });
        }

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

    • aristogeiton's avatar
      aristogeiton
      Frequent Visitor
      8 years ago

      Excellent! It now works! Thanks very much for this!

      • anandsoftweb's avatar
        anandsoftweb
        Advocate V
        8 years ago

        v-viig aristogeiton

         

        I am having same issue color picker does not save in custom visual stack bar.

         

        what I have to do? do you have any example of custom visual.

         

        Please help me.

         

        Thanks,

        Anand

    • ChrisWilliams's avatar
      ChrisWilliams
      Advocate II
      7 years ago

       I know this is an old post, but I wanted to post a modification to this (I'm using the SDK 2.1.0).

       

      In cases where my table was empty, I was seeing an exception in my visual.  I traced it and found that dataView.table.identity can be undefined, which would lead to an exception in this method.  A simple fix is to perform a check for undefined.

       

              private getSelectionIds(dataView: DataView, host: IVisualHost): ISelectionId[] {
            
            if (dataView.table.identity === undefined){
                return [];
            }

            const queryName: string = dataView.table.columns[0].queryName;

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

                return host.createSelectionIdBuilder()
                    .withCategory(categoryColumn, 0)
                    .withMeasure(queryName)
                    .createSelectionId();
            });
        }
      • v-viig's avatar
        v-viig
        Community Champion
        7 years ago

        Can you share whole source code for deeper debugging?

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]