Forum Discussion
Rohit001
2 years agoHelper I
Want help in DAX code
This table i have i want if in one year zero sale then entire row color is changed, if the two years zero sale then another color How to do this
parry2k
2 years agoSuper User
Rohit001 assuming you have calendar table that you are using to show year on the columns of the matrix visual:
Add following measure which will give you count of years with zero sales and then you can use that to set the color and then further use it for conditional formatting:
Color =
VAR __SalesByProduct =
ADDCOLUMNS (
SUMMARIZE ( ALLSELECTED ( 'Calendar'[Year] ), 'Calendar'[Year] ),
"@Sale", [Sales Measure]
)
VAR __CountYearsWithZeroSales = COUNTROWS ( FILTERS ( __SalesByProduct, [@Sale] = 0 ) )
RETURN
SWITCH (
__CountYearsWithZeroSales,
1, "Red",
2, "Green"
)