Forum Discussion

dineshj23's avatar
dineshj23
Helper I
3 years ago

Conditional Formatting with double values

Hi all,  I have the below data imported into PowerBI. I created dates for each of the sales amounts (Sales 1, 2, 3 etc.) with relationship to the  one main calendar. For the matrix visual, I created...
Show and Tell
Tips and Tricks
dineshj23's avatar
dineshj23
Helper I
3 years ago

Anonymous Thank you for looking into this. Below is the example of what I mean. 

Here's the expanded version of a matrix visual showing Stage 3 of "4564" not approved and not highlighted. 

 

But the condensed version shows that "45664" is green. However, there's stage 3 that has not been approved. Someone looking at the condensed visual will think that the sales order is all approved and complete when it's not. 

Any way to fix this? Here's my field value measure I created to highlight this as green. 

Color1 = var m = max(Sheet1[Sales Status])
    Return
        CALCULATE(
            if (m = "Approved","#90EE90",""))

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi dineshj23 ,

     

    Unfortunately, there seems to be no way around this at the moment. If you can, you can create a relevant idea and vote on:

    Ideas (powerbi.com)

     

    Best Regards,

    Stephen Tao