Displaying % in power BI

[guptamols]

My data is structured as below (snippet of data)

ID	Location	Status
AP001	Location5	Booked
AP002	Location3	Pending
AP003	Location2	Lost
AP004	Location7	Lost
AP005	Location4	Booked
AP006	Location2	Lost
AP007	Location6	Lost
AP008	Location1	Booked
AP009	Location7	Lost
AP010	Location5	Lost
AP011	Location5	Lost
AP012	Location8	Booked
AP013	Location3	Pending
AP014	Location4	Pending
AP015	Location2	Lost

<tbody>
</tbody>

In power BI, I want to graph which shows location wise Booked %

I was doing this through "Calculated Item" in pivot table

 

[VBA Geek]

You would do it the same way in power BI. Add a matrix and drag the location on the rows and your measure (calculated item) in the values. Once your data is fine, convert it into a clustered bar chart:

=<br><span class="Keyword" style="color:#0070FF">DIVIDE</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent4">    </span><span class="Keyword" style="color:#0070FF">CALCULATE</span><span class="Parenthesis" style="color:#969696"> (</span> <span class="Keyword" style="color:#0070FF">COUNTROWS</span><span class="Parenthesis" style="color:#969696"> (</span> Table1 <span class="Parenthesis" style="color:#969696">)</span>, Table1[Status] = <span class="StringLiteral" style="color:#D93124">"Booked"</span> <span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent4">    </span><span class="Keyword" style="color:#0070FF">COUNTROWS</span><span class="Parenthesis" style="color:#969696"> (</span> Table1 <span class="Parenthesis" style="color:#969696">)</span><br><span class="Parenthesis" style="color:#969696">)</span><br>