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 formatting (red, green, blue etc). Please help me.

 

Thanks

sreenivasa

Need Help

5 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    8 years ago

    Anonymous if you have blank values and you can add +0 at the end of your measure ie sum(columnname) + 0 or you can do an if(isblank(columnname),0,columnname)

     

    for conditional formatting in the matix object use condition formatting and look at the different options according to your requirements in the settings

    • 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