Forum Discussion

xppdev's avatar
xppdev
Frequent Visitor
9 years ago

Displaying project status.

I have a project where we are trying to display a list of projects with defined steps and statuses. In excel, we are currently using conditional formatting of cells, not really the best way, but it d...
Tutorial Requests
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi xppdev,

 

Have you tried showing the project status on the Matrix visual with conditional formatting for measurement(this is the closest thing I can think on Power BI currently)? See my sample below.:smileyhappy:

 

I assume you have a table called "Table1" like below.

 

 

1. Use the formula below to create a measure.

CountOfCurrentStatus = 
VAR currentStatus =
    FIRSTNONBLANK ( Table1[Status], 1 )
RETURN
    CALCULATE ( COUNTA ( Table1[Status] ), Table1[Status] = currentStatus )

2. Show the measure on the Matrix with Project Name and Status like below.

 

 

3. Apply condition formation for the measure like below.

 

 

Regards

xppdev's avatar
xppdev
Frequent Visitor
9 years ago

That looks like a great idea, but I need each status to have it's own color.

I can get 3 with the matrix's conditional formatting.

Appologies for not including an image earlier, I was having issues getting one added.

 

My thought is there is a better way to show the status of the project. Since each of the columns should be dependent on the others, a final status display with the status should work.

I may have to head the custom visual route.

 

 

Thank you again for the idea!

  • Manikantan's avatar
    Manikantan
    Frequent Visitor
    7 years ago

    Dear,

    Kindly need to check if you were able to accomplish the mentioned image through Power BI. I have a similar requirement and would like to know the same.