COLOR DATA ROWS IN MATIX WITH DIFERENT COLORS

[JESUS7744]

Hello comunity, i have this problem, powerbi WONT allow me to paint the data bars of diferent columns with a diferent color, just one color for all the data bars in all the matrix table , in the example below all the dataBars are blue, I need it like the table below, a color for every column, when i go to the format of the matrix, the option specific column, only reads like there is one colum, but i have 5, i asumme this is because the matix is calculated based on one value , but IT SHOULD NOT DO THAT, if the  nature of matrix live pivot tables is to create multiple calculated columns even if they come from one value, so please, any super power bi user could help with this, and thank you!

 this is what i need

THE values im using

[JESUS7744]

Im looking how to add a measure and nothing, this seems really complicated, dont know how to go about this

[SpartaBI]

If you want to learn it good, and just solve this question, I recommend a course by sqlbi.com. Start with their free introduction courses and go from there. You must know DAX,otherwise you will struggle for every new need

[SpartaBI]

In general, anything related to DAX yku go to sqlbi.com 🙂

In your case it should be something like:

Measure 1 =

CALCULATE([Original Measure], table[Color] = 1) 

Same for the other measures respectievely.

Hope that helps

[SpartaBI]

@JESUS7744 did you see the measure?

[JESUS7744]

I just think, this feature should be in powerbi, is not possible that i had to CODE just to paint a column diferente color, is NOT practical.

[SpartaBI]

With that I can't argue 🙂

[JESUS7744]

thta wont work, I dont have any table named COLOR, just one table call BASEPARQUE

[SpartaBI]

Put your table name where I wrote 'table' in my code.....

[JESUS7744]

Im getting this new error

it says it cant determined the value original measure

[SpartaBI]

No.....   

Original measure was what you put in values.

Write instead SUM(Value).

Listen you must learn basic DAX. We can't progress like this.

If you don't underatand and succeed, please open a new queation in the forum. 

[JESUS7744]

Hello ,I see the example i just dont undestand how to replicate the values the matrix already calculate

[SpartaBI]

You create that measure for each color and put these measures in the value bucket of the matrix. 

If you don't understamd them at all I suggest really to take the introduction courses to know a little bit more what is what, ok?

[JESUS7744]

i undestand that part, what i dont get is whar formula to use or what i had to calculate with what in order to get the % the matrix is aready calculating

[SpartaBI]

I tried my best 🙂 I suggest create thia queation again as a new one in the forum

[SpartaBI]

In order fot that color pallete you need to create a measure for each coloumn 🙂 and remove the coloumn from the colomn tab in the visual. Than you will have in the visual formatting the options the choose color for every column 

[JESUS7744]

thank you but i still dont undestand how to do this

[JESUS7744]

Hello SpartaBi thak you, any tutorial or step by step on how to do this part of  create a measure for each coloumn? im kind of new , and thank you, cant seem to understand how to calculate or formulate the measuares i need to affect back the same table that the matrix already create just to paint each coloum, =( what a mess