Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
what i suggest is to use a matrix visual and turn off stepped layout
Proud to be a Super User!
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.
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
Proud to be a Super User!
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 |
what i suggest is to use a matrix visual and turn off stepped layout
Proud to be a Super User!
you are welcome
Proud to be a Super User!
you are welcome
Proud to be a Super User!
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |