Forum Discussion

MTOnet's avatar
MTOnet
Icon for Helper III rankHelper III
6 years ago

Reading Value in Table When Showing Rows with Blanks

I have to do some custom coloring that cannot and trying to use conditional formatting, but I am not getting the results i was hoping for.  I have tried many methods, but continue to get the same res...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi MTOnet ,

 

You could use ALL() function to ignore the filter. 

However, I still don't kown the reason of blank. Could you please share your sample data and excepted result to me if you don't have any Confidential Information? Please upload your files to One Drive and share the link here.

 

MTOnet's avatar
MTOnet
Icon for Helper III rankHelper III
6 years ago

Hi v-eachen-msft , unfortunately, I am unable to share my dataset.  The client has limited sharing on onedrive to those within the corporate network.

 

I did try to use the all() function, but when I did so, all statuses (including those that had been previously been blank) gave a color result of 4.  Here is what I tried.  Let me know if you think it should be done differently

Testcolor =  maxx(all(Defects),SWITCH(true,
    Defects[Status]="01-New",1,
    Defects[Status]="02-Reopen",2,
    Defects[Status]="03-Revisit",1,
    Defects[Status]="04-Open",2,
    Defects[Status]="05-Fixed",3,
    Defects[Status]="08-Return",4,
    Defects[Status]="07-Retest",4,
    Defects[Status]="06-Repair",4,1
))