Sales Scorecard: Where are we losing money? by Decisive Data

Summary "How is my company doing?" It's a question we hear often. It seems simple enough, but answering it is a complex process. This report is designed to answer the question in a clea...

Business

Other

Adolfo

Regular Visitor

9 years ago

Hi JaredK, You did a good job. This dashboard shows very quickly where we need to be focused.

What component did you use to paint "where are we unprofitable" matrix or table and how did you paint it?

Thank you very much.

Adolfo

Anonymous

Not applicable

9 years ago

Hey Adolfo, great question! I'm using the Conditional Formatting feature of Power BI. I chose to use a table because conditional formatting wasn't available in matrices when I first created this. You could do this in a matrix now, but I chose to stick with a table because I preferred the look and format.

Once you create your table/matrix, in the Values field well click the drop down next to the measure you want to use to color your cells. I wanted only 2 colors, so I set my min and max to be 0 - anything positive is grey, anything negative is red.