Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |