cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## how to add condition format to a switch true value

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?

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

1 ACCEPTED SOLUTION
Community Support

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.

6 REPLIES 6
Community Support

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.

Super User

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

Helper III

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

Super User

Hi @oakfootballclub

Look into Percent & number

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

Super User

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

Helper III

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