Power Query: How do i display the name of columns in an axis and use their values ?

[Anonymous]

Hello,

I need to make a graph as shown bellow that represents the reasons of delays; as an axis there are the names of columns and as a value it is the percentage represented by the number of "Y" in each column divided by the number of "Y" in the "Delayed" column.

How can i represent this in power bi ?

Thanks in advance

 

 

[CNENFRNL · Accepted solution]

I assume that a project is delayed as soon as any one of the reasons is Y; so that the "Delayed" column isn't necessary.

Unpivot the above dataset for DAX calculation,