Gauge Configuration to Show Orders Delivered in Time as a Percentage

[TimmK]

I would like to visualize how many orders have been delivered in time as a percentage, using a gauge. Yet, I struggle to figure out how to configure the gauge.

My aim is to show the orders delivered in time as a percentage of the total number of orders for a specific period of time (I use a slicer to filter the date, for example August, 2020). However, as you can see below only the total number of orders are displayed.

The second picture shows the underlying table. The attribute 'LF' is the order number, the attribute 'OTD (B)' shows if the order has been delivered in time. The value 'Pünktlich' means delivered in time, 'Verspätet' means delivered too late.

How can I configure the gauge so that it displays what I want? Is it necessary to transform my table?

 

  

[amitchandak]

@TimmK , You have to create a measure like

divide( calculate([Count K LF], filter(Table, Table[OTDB] ="OTD")),[Count K LF])

replace with actual ontime file

[TimmK]

@amitchandak Thank you greatly for your helpful answer. I used measures and got the following result:

However, is it possible to make it look like the following one (which is from an Excel file), especially with regards to the red, yelllow and green areas? 

[v-yiruan-msft]

Hi @TimmK ,

Please check if the following custom visuals can achieve your requirement.

Tachometer Gauge

Power BI Custom Visuals - Dial Gauge

Advanced Gauge for Power BI

5 Advanced Gauge Customization for Power BI

Best Regards

Rena