Forum Discussion

Sander_NL's avatar
Sander_NL
Helper I
6 years ago
Solved

How to visual process steps completed or not

Hi,

 

I've loaded a lot of progress steps from a Sharepoint list. In Power Query I've created columns to have a column for each step to see if it's completed or not (only 2 phases are displayed for now for demo)

 

Now I want to visualize this in this way: where red is completed. The not completed steps can be blank or a different color is also fine. 

 

 

What is the best way to achive this?

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    1. Use matrix visual to satiesfy your requirment
    2. matrix visual will give you conditional formatting option in formate section where you can set the background colors depends on condition.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    1. Use matrix visual to satiesfy your requirment
    2. matrix visual will give you conditional formatting option in formate section where you can set the background colors depends on condition.
    • Sander_NL's avatar
      Sander_NL
      Helper I
      6 years ago

      Thanks Anonymous thanks for your hint! I needed to change the values completed / not completed into 1,0 first.