Forum Discussion
How to select field for Conditional formatting
Hello friends,
I want to add Conditional Formatting for my Table Visual, and it suppoed to be based on value of a field.
Open this function in Format :
But I can't choose it, any reason why ?
Thanks
admin_xlsior , you should be able to choose a measure or column, They should return text, field value except color are returning
example
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
3 Replies
admin_xlsior , you should be able to choose a measure or column, They should return text, field value except color are returning
example
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4Hi amitchandak
Actually, I only need to choose column ->
I also thought it is should be simple, but the fact is I cannot choose it, it is stay like my first image, so cannot select it.
To be honest I think I have this problem before, if not mistaken, but it is long time ago and I forget why and how to resolve it 😅
Thanks,
Ahh... my bad, I supposed to select Format by : Rule instead Field value.
Sorry for the trouble.
Thanks
