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 table:


Now I would like to add additional conditional formatting that all what come before the blue color will be fill with grey color like in the picture below:

 



There is possible? if not there is another way beside conditional formatting to perform this?

Thanks a lot!

 

 



  • Hi Anonymous

     

    This is your expected output, right?

     

     

     

    pbix is attached for your reference.

     

    Hope this helps

4 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion

    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

      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
        Community Champion

        Hi Anonymous

         

        This is your expected output, right?

         

         

         

        pbix is attached for your reference.

         

        Hope this helps