cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## COLOR DATA ROWS IN MATIX WITH DIFERENT COLORS

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

17 REPLIES 17
Regular Visitor

Community Champion

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

Community Champion

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

Community Champion

@JESUS7744 did you see the measure?

Regular Visitor

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.

Community Champion

With that I can't argue 🙂

Regular Visitor

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

Community Champion

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

Regular Visitor

Im getting this new error

it says it cant determined the value original measure

Community Champion

No.....

Original measure was what you put in values.

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.

Regular Visitor

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

Community Champion

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?

Regular Visitor

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

Community Champion

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

Community Champion

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

Regular Visitor

thank you but i still dont undestand how to do this

Regular Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors