Power BI Visualization & Filter Assistance

Job ID: 39000328

Budget: $10 – $30 USD

I am Looking for the Help in Power bi Visual> I have Total 5 Column Which are Commodity, User, Date, Coo and Order_Count
The requirement is as Below

1) Wanted to Use Table as A Visulization (Specificallt table Not Metrix)
2) Group by User and sort by Date
3) Identify Which user which Comoddity is using (this should be Sorted by date ASC)
4) first Condition: If user is buying Commodity lets say 1*honourl as an example and we found User Switch Different Comoddity then for that entire line (Commodity, User, Date, Coo and Order_Count) font Colour Should be Hilighted Orange (See Attached Example 1)

Second Condition: If user are not buying the target commodity at all (I will provide you the targeted commodity list) then mark font Colour as Red for All Coloum

Third Condition: if user are buying target Commodity(I will provide the Targeted Comoddity list) Through its all order then mark as Dark_green

Forth Condition: if User is buying Targeted Commodity then he Switch to other Commodity then Again he Back to target Commodity then that whould be Light Green

5) For these above 4 Condition needs to Create Filter Button a Side (With above Color) OR Switch button which Filter the view As per the above Condition
Related categories: Data Science Power BI