Conditional formating in a table

[kelcicoe]

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?

[kelcicoe]

Thanks for your reply,  I am relatively new to powerbi and creating new measures.  Do you have any sample code to create a % change?

[beckemeyer]

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."

[kelcicoe]

Thanks for your reply. % change?

[beckemeyer]

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.