Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
I like to create color for whole row.
My PBI file :-
https://www.dropbox.com/s/l8yfe84nnblk6oq/PBT_V2021_400%20GL_TI.pbix?dl=0
Paul
Solved! Go to Solution.
Hi @admin11 !
You can create a new cloumn [Group_Type_Color] in your model using below DAX which can be used for Coditional Formatting;
Group_Type_Color = SWITCH ( TRUE(),
'Group TYPE'[GROUP_TYPE] = "G9", "Green",
'Group TYPE'[GROUP_TYPE] = "G11", "Yellow",
'Group TYPE'[GROUP_TYPE] = "G13", "Blue",
"")
Now you can go to condtional formatting, background color -> On -> Advanced control;
Regards,
Hasham
Hi @admin11 !
You can use condtional formatting option to set background color property based on dynamic condition. You can use below article for refrence how to add conditional formatting. You need to set this background property for each column in table.
Use conditional formatting in tables
Regards,
Hasham
Hi @admin11 !
You can create a new cloumn [Group_Type_Color] in your model using below DAX which can be used for Coditional Formatting;
Group_Type_Color = SWITCH ( TRUE(),
'Group TYPE'[GROUP_TYPE] = "G9", "Green",
'Group TYPE'[GROUP_TYPE] = "G11", "Yellow",
'Group TYPE'[GROUP_TYPE] = "G13", "Blue",
"")
Now you can go to condtional formatting, background color -> On -> Advanced control;
Regards,
Hasham
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |