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 t...
Need Help
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.

 

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

    I've since updated to the June 2018 release of Power BI Desktop, and the issue persists. :(

    Can someone please confirm if this is indeed a bug?  Thank you. :smileyhappy:

    • khabaleshrikant's avatar
      khabaleshrikant
      New Member
      4 years ago

      Hi Fred,

       

      hope you are doing well.

      did you find solution to this requirement.

      I am also facing same issue. Sort column disable conditional formatting in power bi