how to add condition format to a switch true value

[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")

)

[v-yilong-msft · Accepted solution]

Hi @oakfootballclub ,

I create a table and a matrix as you mentioned.

Then I create a measure and put it into Conditional formatting.

Measure = 
IF (
    MAX ( 'Table'[Class] ) = 3,
    "Yellow",
    IF ( SUM ( 'Table'[Score] ) > 100, "Red", "Green" )
)

Best Regards

Yilong Zhou

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

[PijushRoy]

@oakfootballclub  You applied the Conditional Icon in Value section Increase % field?
Can you please share snapshot for applied steps

[oakfootballclub]

please check the apply step:

cal_amount_FYTD_CHN_Matrix=

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")

)

[PijushRoy]

Hi @oakfootballclub 

Look into Percent & number

Better you create a samle pbix file with sample data and share the link (Google Drive. Sharepoint, Dropbox)

[PijushRoy]

Hi @oakfootballclub 

Can you try below steps

After that, select Field value and select the measure

Let me know if that works for you

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[oakfootballclub]

Yes of course I tried this step so I get all columns to have the arrow, the problem is that I need not the arrow with non% columns