how to add condition format to different values when added column in matrix

[oakfootballclub]

Hi experts, I created a dimension table as column name of matrix, and created switch true measure as value, but I need to add icons only to % values, when I added the icon, all columns shows, how to set in order to only the % columns has the arrow icons?

dimension table as column header

measure I created:

value=

SWITCH(SELECTEDVALUE(dim_2Y[num]),

1,IF(ISBLANK([cal_amount_FYTD_PreviousM_FY-1]),"-",[cal_amount_FYTD_PreviousM_FY-1]),

2,[cal_amount_FYTD_PreviousM_Increase%_Y-1],

3,[cal_amount_FYTD_PreviousM],

4,FORMAT([cal_amount_FYTD_PreviousM_Increase%_Y], "Percent")

)

all columns show the arrow icons

here is the matrix I created:

expected result: only the percent value column has the arrow condition formatting

[Ritaf1983 · Accepted solution]

Hi @oakfootballclub 

You cannot format these columns separately because there is only one "Measure" to base the styling on.

Therefore, either you also need to add the arrows with DAX, or give up on the whole dynamic measure thing and do it the simple way with 2 measures.

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly