Comparing three fields to show value add of item

[dswallow]

Hi, I would love some advise on how to compare the impact vs. effort required fields I have for my values. I have an excel with a list of company initiatives, I have three fields called cost impact, support impact and effort required. These 3 fields can have the values 'Low, Medium or High'. I would like a way to compare these values for each initiative. 

Maybe I could have some sort of matrix or use a gauge for each to show low, medium and high?

Any suggestions would be appreciated!!

[Idrissshatila · Accepted solution]

Hello @dswallow ,

You could use a matrix and add conditional formatting to show Low in a color, meduim in a color and high in a color.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

Follow me on Linkedin