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!