Forum Discussion
Conditional formating in a table
Hi, I am trying to change how the icons work in the above graph. This is looking at use of an abx by month. I want the icons to be in response to individual abx. So for instance, the first column of data if it increases from one month to the next I would want it to be green and if it decreases than to be red or if it stays the same then yellow. Is this possible?
4 Replies
It should be possible, but what you'll need to do is create additional measures/columns in the background that measure the MoM raw or % change, and then tie the conditional formatting to that field, but in the target cell/column you're looking for. You can basically tie conditional formatting to whatever you want in the column, but most I think assume it has to be tied to the cell value that's currently in the cell.
Thanks for your reply. % change?
Thanks for your reply, I am relatively new to powerbi and creating new measures. Do you have any sample code to create a % change?
Great question! Home ribbon tab at the top, then quick measures. From there you should be able to use MoM. Otherwise, you'll need to take [target month] - LOOKUP(DATEADD( )). At least that's how I would approach that problem. There are also great articles I found after Googling for "Month Over Month Change DAX."
