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
Im looking how to add a measure and nothing, this seems really complicated, dont know how to go about this
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
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
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.
thta wont work, I dont have any table named COLOR, just one table call BASEPARQUE
Im getting this new error
it says it cant determined the value original measure
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.
Hello ,I see the example i just dont undestand how to replicate the values the matrix already calculate
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?
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
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
thank you but i still dont undestand how to do this
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
