Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Icon Conditional Formating using DAX to find Value

Hello Community,    I am trying to add the icon to my column SP data feed matrix [OVERALL_RATING] which have 4 value Acceptable, Marginal, VALUE MISSING, Not Acceptable.  The ending result, I woul...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak Thank you so much for your reply however I am trying to do conditional formatting using a text instead of whole number, I tried to copy exact the code and only change the color format but it will give me trouble. 

 

Here is my updated DAX it have the error code "The syntax for 'data' is incorrect"

 

OVERALL_RATING icon =
SWITCH (
TRUE (),
'SP data feed matrix'[OVERALL_RATING] = Acceptable , "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='100' height='100' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='purple' stroke-width='4' fill='purple' /> </svg>",
'SP data feed matrix'[OVERALL_RATING]= Marginal, "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='100' height='100' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='green' stroke-width='4' fill='dark green' />
'SP data feed matrix'[OVERALL_RATING]= "VALUE MISSING", "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='100' height='100' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='green' stroke-width='4' fill='dark green' />
'SP data feed matrix'[OVERALL_RATING]= "Not Acceptable", "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='100' height='100' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='green' stroke-width='4' fill='dark green' />
</svg>",
)
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

I noticed that you didn't add the "" to include the text Acceptable,Marginal...in the dax expression. 

Here's icon formatting post probably could be your reference:

https://community.powerbi.com/t5/Desktop/Icons-Color-formatting/m-p/747856 

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/ 

If the problem still exists, Would you mind kindly share your dummy pbix? please make sure you've removed the confidential info before.I'd like to check it further.