What format is returned from colorPalette.getColor ()? Hex, RGB etc

Anonymous — Fri, 08 Jun 2018 15:19:44 GMT

Hi there

I am attempting to change one line in pbiviz.json file to update the color:

Change json code from:

var m = e.getColor(h.toString());

(above works and cycles through the different colours in the colour pallette)

To (does not work):

var m=\"#ED1C24\";

or

var m=\"ED1C24\";

or

var m=\"red\";

None of the above works, and the visual always comes out black, irrespective of the hex code / color name used.

My query is then what does e.getColor(String) return?

Thank you

Re: What format is returned from colorPalette.getColor ()? Hex, RGB etc

v-viig — Mon, 11 Jun 2018 08:07:37 GMT

The getColor method returns an instance of IColorInfo.

To fix the issue you should return an object like this:

{
  value: "#ED1C24"
}

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

Anonymous — Mon, 11 Jun 2018 13:16:59 GMT

Great, thanks @v-viig!

More details ....

getColor (string) returns IColorInfo in the format:

{ value: '#FFFFFF' }

See line 39 of:

For example, JSON in Power BI visual is updated from:

m = e.getColor(h.toString());

To:

m={value:'#009EEC'};

to override the colour in the visual.

Power BI uses D3 for colour management: https://github.com/d3/d3/wiki

And ordinal scales in particular:

Download Winrar or similar zip utility
Download the visual .pbiviz file
Within Winrar, navigate to the .pbiviz file
Click on the .pbiviz file within Winrar (this is a zip file) and Winrar should open the file and show:
1. resources (folder)
2. packages.json (file)
Click on resources folder within Winrar (don't extract yet)
Copy the .pbiv.json file from within resources, eg: Aquarium1442671919353.pbiviz.json to another windows folder
Edit Aquarium1442671919353.pbiviz.json in a text editor as required
Do a find and replace within Aquarium1442671919353.pbiviz.json and change '1442671919353' to another unique number, eg: '1442671919354'
Save as a new filename eg: Aquarium1442671919354.pbiviz.json which matches your 'find and replace' in step 8.
Copy Aquarium1442671919354.pbiviz.json back into the resources folder within Winrar (recommend that you keep Winrar window open for easy copying of files back into the .pbiviz file)
Extract packages.json and edit in a text editor. Do a find and replace within packages.json as per step 8. Eg Find 1442671919353 and replace with 1442671919354
Save package.json and copy back into Winrar overriding the existing packages.json
Import the custom visual into Power Bi as normal. If Power BI gives an error, double check that all the renaming of the .pbiviz.json filename and contents within .pbiviz.json and within package.json are consistent. Also check that the JSON edits in step 7 are correct

In my experience, the following didn't work:

I had to keep the .pbiviz folder open within Winrar and copy the edited files back into the Winrar window.