Forum Discussion
Up and Down Arrow Keys Indication
I have the data matrix below and i want to add another column to the end of the matrix. The criteria for the new column is if max(date) count is greater than max(date)-1 count then the cell should indicate a up arrow in green color. otherwise max(date) count is less than the max(date)-1 count the cell should indicate a down arrow in red color. How to achieve this. I have attached th .pbi file link also. https://drive.google.com/file/d/1HNrYIGre6MbXrOD2wepByEJUnXf2I17O/view?usp=drive_link
Final ouput might look like this:
color arrows red or green as well.
Thank you for providing the sample data. Your request requires a lot more work than you may think, as you need to consider various scenarios. Please check my proposal.
1 Reply
- lbendlin
Super User
Thank you for providing the sample data. Your request requires a lot more work than you may think, as you need to consider various scenarios. Please check my proposal.