Forum Discussion

FredTheFrog's avatar
FredTheFrog
Icon for Advocate I rankAdvocate I
8 years ago

Conditional formatting disabled by Sorting on another unrelated column

April 2018 version of Power BI Desktop.  Oracle 12c database using Enterprise Data Gateway and Direct Query mode.  Very simple report with a heading, one table visual, and one horizontal slicer for the data.  When assigning columns/data values to the table visual, conditional formatting of an integer value/column is available and functional.  After adding the slicer, it was apparent the sort/order of the slicer button values was not correct.  I elected to sort the text field displayed on the slicer buttons by a time value in the data table.  At this point, the conditional formatting vanished.  Neither the slicer value nor the sort by value are the value being conditionally formatted. :(  Removing the sort by condition restores conditional formatting.

 

Thanks in advance for any suggestions!

Need Help

5 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi FredTheFrog,

     

    Which data type your sorted column? In addtion, you said "At this point, the conditional formatting vanished.  Neither the slicer value nor the sort by value are the value being conditionally formatted. ". Could you give some screenshots and clarify more details about your issue?

     

    Regards,

    Jimmy Tao

    • FredTheFrog's avatar
      FredTheFrog
      Icon for Advocate I rankAdvocate I
      8 years ago
      Jimmy: Sorted column is a VARCHAR string. KEY VALUE for the sort is a TIMESTAMP with associated TIME ZONE. Conditionally formatted column is an INTEGER value that varies from zero (0) to four (4). I will prepare and submit a generic example later today for review. What is interesting is the conditional formatting rules remain present. Removing the SORT BY modeling restores correct function immediately.
      • FredTheFrog's avatar
        FredTheFrog
        Icon for Advocate I rankAdvocate I
        8 years ago

        I created a small generic example this afternoon, and the same bug appeared.

        Until such time as I performed the SORT BY, the conditional formatting functioned correctly.Table Visual before Sort By is applied

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        As soon as I applied the SORT BY, the conditional formatting no longer functioned.Table Visual after Sort By is applied

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        This is the data screen showing the columns.  To obtain the correct sort on the GROUP_NAME column, it is being sorted by the SLA_TIME column.  Conditional formatting is applied to SLA_STATUS column as follows: 0 = white, 1 = green, 2 = yellow, 3 = red, 4 = dark red.  Removing the SORT BY condition restores the conditional formatting.