different groups of data highlight/change colour make to make it easy to read

[dd88]

I have a column with data of family surname and another column that contains family members first name.

the visual is a the table. To make it eaiser to read, when the surname group (value changes) is there a way to change colour, to easily identify the the differnt groups?

TIA

[v-yohua-msft]

Hi, @dd88 

First, you'll need to create a measure that assigns a unique color based on last name. This measure can be assigned color using the or DAX functions.

Color Measure = 
SWITCH(
    TRUE(),
    [Surname] = "Smith", "lightblue",
    [Surname] = "Johnson", "lightgreen",
   
    "defaultColor"
)

Go to the table visual, and under the Visualizations pane, find the column that you want to format. Click the drop-down arrow next to the column name, select Conditional formatting, and then select Background color or Font color, depending on your preference.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

I suggest you to show the data in the matrix visual. Then it will be easier to see the surname group

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual?wt.mc_id=DP-MVP-5004616

[dd88]

Hello @ryan_mayu 

please find sample data ..

Surname	First name
Adams	Lee Adams
Adams	Shane Adams
Adams	Elle Adams
Adams	Jack Adams
Brown	Anthony (Tony)
Brown	Kylie Brown
Clark	Danelle Clark
Clark	Sue Clark
Clark	Lee Clark
Clark	Lana Clark
Clark	Jacob (Jake) O'Donnell
Carter/Cooper	Tina Carter
Carter/Cooper	Rob Cooper

[ryan_mayu · Accepted solution]

what i suggest is to use a matrix visual and turn off stepped layout

[dd88]

Thanks @ryan_mayu  yes that looks great and meets the user requirements. 

[ryan_mayu]

you are welcome

[dd88]

Many thanks @ryan_mayu  I will look into it ..

[ryan_mayu]

you are welcome