Monday, August 24, 2009

Condtional formatting for Dates and Currency....

This is the technique format property of dates
=switch(fields!mylocale.value="DE" ,"d.MM.yy" ,fields!mylocale.value ="UK","d/MM/YY",
feilds!mylocale.value="US","M/d/YY")

This is the technique format property of currency

=switch(fields!mylocale.value="DE" ,"de-DE" ,fields!mylocale.value ="UK","en-GB",
feilds!mylocale.value="US","en-US")

How to display the alternate rows in different color ?

In ssrs you can select detail section of the report
goto the properties,on color goto the expressions--->
write a code
=IIF(ROWNUMBER(NOTHING) MOD 2,"RED","GREEN")

Search This Blog

DAX - Grouping on multiple columns and the count

Please go thorugh the below URL for entire soultion. http://community.powerbi.com/t5/Desktop/DAX-Grouping-on-multiple-columns-and-the-cou...