Forum Discussion
Conditional formatting is not working for Matrix table based on text column
Hi,
Im new in this, Im tryiying to set conditional formatting for percentage values. Those values are based from a month column and a text column. When i set this in the matrix I see the % values of compliance for each month but when I try ti change the default values (0-33%, 33-67% & 67-100%) to (0-85%, 85-90% & 90-100%) it gets crazy.
Please help
https://drive.google.com/open?id=1ljLDLBiI0kNVt1JW3ROUEFEcjpTAAZyS
Anonymous solution attached, there are two measure that make it work.
Would appreciate Kudos if my solution helped.
5 Replies
- parry2kSuper User
Anonymous Hey I cannot access the file, can you make sure it is shared to download
- AnonymousNot applicable
https://1drv.ms/u/s!Au_UwQhCaB6egswQIfXCycGssKch2A?e=ebye0b
Here´s the info. Thx a lot
- AnonymousNot applicable
- parry2kSuper User
Anonymous solution attached, there are two measure that make it work.
Would appreciate Kudos if my solution helped.
- v-eachen-msftCommunity Support
Hi Anonymous ,
Could you please share your sample data and excepted result to me if you don't have any confidential Information. Please upload your files to One Drive and share the link here.