Forum Discussion
Matrix conditional formatting if value is lower then previous year then red
Managed to fix it by instead of count using sum in the formale since my table already"counts" the values.
Condittional formatting =SWITCH (TRUE (),SUM('Export'[COUNT] )< CALCULATE (SUM('Export'[COUNT] ),SAMEPERIODLASTYEAR ( DateTable[Date])), "#ff8800")final resultExtra credit to MFelix for all the help provided!
Thanks for your reply MFelix ! Yes yes I changed the code to suit the weekly period as well so here is a summary of what I'm trying to do
So, I am trying to remove the formatting from the first column. This is essentially weekly quantity of a different products, with products on x axis and weeks on y axis. The idea is to highlight the cell if the value is more (green) or less (pink) than the previous week. I created this measure and applied as field value in conditional formatting.
Super UserHi Anonymous ,
Can you share a sample of your data model?
MFelix for some reason Power BI is not allowing me to post it here nor am I able to send you a private message. Please advise
- MFelix
Hi Anonymous
To share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.MFelix its not allowing me to post any link or file for some reason (saying post flooding detected). Can I email you somewhere?