Forum Discussion
Color Coding based on a dimension in a matrix
Hi Everyone,
I started using Power BI from 2-3days. I am trying to create a report with Matrix.
I have taken date(as weeks in columns) and Names in Rows and field1(a dimension basically) and field2(Measure) in Values.
Now i want to color the report based on field1.
Field1 is having values like this:: a,b,c,d, general etc.,
If a then 'Green'
else if b then 'Light Green'
else if c then 'Red'
else if d then 'Blue'
else 'yellow'
But so far i have seen field1 is taking to summarization and so if i go for conditional formatting i couldn't take as a proper dimension rather it is giving me first/last/count/countd. I couldnt de summarize it and apply color here.
Is there any way that i can apply color to my cells based on the dimension values in a matrix format.
Hi lprabhal
I would suggest you add an index column in query editor and drag it in matrix.Then create a measure and use it in conditional formatting.
Measure = SWITCH(MAX(Table1[filed1]),"a",1,"b",2,"c",3,"d",4,5)
Regards,
1 Reply
Hi lprabhal
I would suggest you add an index column in query editor and drag it in matrix.Then create a measure and use it in conditional formatting.
Measure = SWITCH(MAX(Table1[filed1]),"a",1,"b",2,"c",3,"d",4,5)
Regards,