Dax expression

[Anonymous]

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

[vanessafvg]

@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]

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]

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]

Hi

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

Thanks

sreenivasa

[v-jiascu-msft]

Hi @Anonymous,

This isn't supported by now. Please vote the idea: better-conditional-formatting-tools.

Best Regards!

Dale