change data bar color in matrix

[rawmeat]

Hi all,

I am using data bar in the matrix to show the measures. 

The users also want to add color on the data bar. (Not the background color, only the data bar color)

So let's say if the number is big, the data bar will be longer and color will be deeper.

Please let me know if there is a workaround for this one.

Thanks much

[Sean]

Depending on how many levels you actually have in your Matrix - a workaround could be to use a Bar Chart.

You can set the Inner Padding on the Y-Axis to zero

Drag the same field that is in your Values to the Color Saturation and then assign the Min and Max colors in the Data Colors menu

Good Luck!

[rawmeat · Accepted solution]

Hi,

We have multiple dimensions so we have to use the matrix.

There is a workaround we create new measure (1 - [measure]) and then set data bar to be white and right to left and set the background color. Although the matrix looks a little bit wired (data bar size is not equal to the whole placeholder) the users still accept this one.

Thanks

Jason

[v-chuncz-msft]

@rawmeat,

There isn't any available way. You may submit an idea via https://ideas.powerbi.com/forums/265200-power-bi.