Skip to main content
cancel
Showing results for 
Search instead 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

Reply
oakfootballclub
Helper III
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?

 

dimension table as column header

oakfootballclub_0-1718346970070.png

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
v-yilong-msft
Community Support
Community Support

Hi @oakfootballclub ,

I create a table and a matrix as you mentioned.

vyilongmsft_0-1718761196307.png

vyilongmsft_1-1718761262923.png

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

vyilongmsft_2-1718761666855.png

 

 

 

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.

View solution in original post

6 REPLIES 6
v-yilong-msft
Community Support
Community Support

Hi @oakfootballclub ,

I create a table and a matrix as you mentioned.

vyilongmsft_0-1718761196307.png

vyilongmsft_1-1718761262923.png

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

vyilongmsft_2-1718761666855.png

 

 

 

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
Super User
Super User

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

please check the apply step:

oakfootballclub_0-1718349591127.png

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

 

Hi @oakfootballclub 

Look into Percent & number

PijushRoy_0-1718350341711.png

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

 

PijushRoy
Super User
Super User

Hi @oakfootballclub 

Can you try below steps

PijushRoy_0-1718348572515.png

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors