Displaying % in power BI

[guptamols]

My data is structured as below (snippet of data)

[TABLE="width: 225"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Location[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]AP001[/TD]
[TD]Location5[/TD]
[TD]Booked[/TD]
[/TR]
[TR]
[TD]AP002[/TD]
[TD]Location3[/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]AP003[/TD]
[TD]Location2[/TD]
[TD]Lost[/TD]
[/TR]
[TR]
[TD]AP004[/TD]
[TD]Location7[/TD]
[TD]Lost[/TD]
[/TR]
[TR]
[TD]AP005[/TD]
[TD]Location4[/TD]
[TD]Booked[/TD]
[/TR]
[TR]
[TD]AP006[/TD]
[TD]Location2[/TD]
[TD]Lost[/TD]
[/TR]
[TR]
[TD]AP007[/TD]
[TD]Location6[/TD]
[TD]Lost[/TD]
[/TR]
[TR]
[TD]AP008[/TD]
[TD]Location1[/TD]
[TD]Booked[/TD]
[/TR]
[TR]
[TD]AP009[/TD]
[TD]Location7[/TD]
[TD]Lost[/TD]
[/TR]
[TR]
[TD]AP010[/TD]
[TD]Location5[/TD]
[TD]Lost[/TD]
[/TR]
[TR]
[TD]AP011[/TD]
[TD]Location5[/TD]
[TD]Lost[/TD]
[/TR]
[TR]
[TD]AP012[/TD]
[TD]Location8[/TD]
[TD]Booked[/TD]
[/TR]
[TR]
[TD]AP013[/TD]
[TD]Location3[/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]AP014[/TD]
[TD]Location4[/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]AP015[/TD]
[TD]Location2[/TD]
[TD]Lost[/TD]
[/TR]
</tbody>[/TABLE]

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>