cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bazam Frequent Visitor
Frequent Visitor

Table Visualization

Dear Expert,

 

I have dashboard. I used the Table visualization see below: on the agent status column i want to change the background color depends on the status. ex if EMAILS red; break green; etc.  How to achieve that?

 

your support is highly appreciated

 

 

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Table Visualization

Hi @bazam,

 

You can create a calculated column:

 

Condition = SWITCH('Table1'[Agent Status],"Break",1,"Emails",2)
 
w1.PNG
 
Then set conditional formatting for the Agent Status column based on this new column: 
w2.PNG
 
Best Regards,
Qiuyun Yu 
Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Table Visualization

Hi @bazam,

 

You can create a calculated column:

 

Condition = SWITCH('Table1'[Agent Status],"Break",1,"Emails",2)
 
w1.PNG
 
Then set conditional formatting for the Agent Status column based on this new column: 
w2.PNG
 
Best Regards,
Qiuyun Yu 
Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.