Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Table conditional formating

Hi all, I need some help with the conditional formatting: I have this Data set: And I performed conditional formating when some integer from the Blue color col is appear and I got this...
Need Help
  • mussaenda's avatar
    mussaenda
    5 years ago

    Hi Anonymous

     

    This is your expected output, right?

     

     

     

    pbix is attached for your reference.

     

    Hope this helps

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous , can we have your sample dataset where we can copy the data to meet your requierement? 

Thank you.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI mussaenda , unfortunately I can't share the PBI file (because I don't have permissions to do it).
However I can send the table and you can copy it into Excel file?
Please find the detailed table:

TitleTotalNew RequirementFrist TestApprove Test 1Second TestApprove Test 2Blue Color
Task ANew RequirementNew Requirement    1
Task BNew RequirementNew Requirement    1
Task CApprove Test 1  Approve Test 1  3
Task DApprove Test 1  Approve Test 1  3
Task ESecond Test   Second Test 4
Task FApprove Test 2    Approve Test 25


 Thanks a lot!

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Anonymous

     

    This is your expected output, right?

     

     

     

    pbix is attached for your reference.

     

    Hope this helps

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks!! It's works!