Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dax expression

Hi   How to write DAX Expression in matrix table having multiple columns, in that we have two or three columns having blank vlaues , then remaining column which is having data should display color ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

country    A     B    C

 

India       1      2     3

USA               8      3

UK           4            9

AUS        8     4     5

 

Above some data is blank in USA and UK columns , My scenario in USA 'A' is blank , USA B and C having values. The values which are showing B is 8 and C is 3 in USA should display any some color. How to write DAX Expression for this. Please help it.

 

Thanks

sreenivasa

 

 

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Did you mean if USA-A is blank, the USA-B and USA-C are colored or are colored by different colors? If so, I afraid this feature is on the way yet. Please vote this idea or create a new idea. 

 

Best Regards!

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi

     

    USA 'B' and 'C' both data should come red color.

     

    Thanks

    sreenivasa