Truck Visual in powerBI

[prv_1401]

 hey guys , Is it possible to create a truck like this and show the fill rate % in the visual in powerBI ??? If the value greater than 99 it shud be shown in green and lesser than 99 in red . 

Share your thoughts or any idea about it . It will be really helpful. Thank you all 

[lbendlin]

here's one possible implementation

[prv_1401]

Thanks that did work. However I was able to get the exact visual using infographic designer.

[Ankh-Uchral]

hi, can you tell me method

[prv_1401]

Hi, Yes I will mention all the steps below which I followed to get this desired output.

1. Firstly, we need to get a truck image and place it in the dashboard like this

2. Next we need to go to the app source where we can add third party visuals to our reort. In this case I used Infographic Designer 1.9.7 visual ( to design the green boxes)

3. Then I added the Fill rate column as measure  and date column as categroy  in the chart.
 Please refer the below images to know how I had designed the visual.

Here you get to see how I have chose the shape style, enabled multiple units so that I can get multiples boxes as shown in the image, unit count by set to row and column , column count, units in a column, fill percentage, colour and finally the fill direction from bottom to top.

The general idea was to depict the exact truck visual with goods filled in it. Unfortunately we couldn't achieve applying conditional formatting in the infographic visual. But we had created few measures to show the Fill rate value and an icon to change dynamically (green/red) based on the percentage value. Fill rate % was a direct column so simply apply conditional formatting to it. For the icon, below are the measures created 
1. Icon - 

Icon =

var positiveicon = unichar(9650)

var negativeicon = unichar(9660)

var result = if([FR %]>0.99,

positiveicon ,

negativeicon)

return result

2. Icons colour 

icon colour = if([FR %]>0.99,"green","red") - Add this measure as field section in conditional formatting option for the icon card.

Based on the selection of filter (Date), output would be like this as shown in the below image.

Regards, 
Praveen