Forum Discussion

neonanora's avatar
neonanora
Regular Visitor
5 years ago

Conditional formating using DAX not working when show all data, yet it works by slicing the data

I have 2 tables, EVP and VP, both connected by EVP program ID.
And I have 1 measure DAX that converts EVP program ID into a number like this.

 

 

Then, I used the number from the measurement to create conditional formatting (to color the background and font)

 

But, why the color is not shown when table VP display all data?
Strangely, the conditional formatting works well if I select a data in EVP table? I have applied same method on 2 other tables and it works fine. Please help

 

Show all data

 

Select a data

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi neonanora ,

     

    Can you kindly share some sample data and the expected result to help me in order to have a clear understanding of your question? I can do some tests to help you figure out this issue.

    You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

     

    Best Regards,

    Yuna