Truck Visual in powerBI

prv_1401 — Mon, 05 Sep 2022 19:24:42 GMT

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

Re: Truck Visual in powerBI

lbendlin — Wed, 07 Sep 2022 00:43:41 GMT

here's one possible implementation

Re: Truck Visual in powerBI

prv_1401 — Sun, 11 Sep 2022 12:55:27 GMT

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

Re: Truck Visual in powerBI

Ankh-Uchral — Wed, 21 Feb 2024 02:05:52 GMT

hi, can you tell me method

Re: Truck Visual in powerBI

prv_1401 — Wed, 28 Feb 2024 13:15:58 GMT

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

topic Re: Truck Visual in powerBI in Custom Visuals Development Discussion

Truck Visual in powerBI

Re: Truck Visual in powerBI

Re: Truck Visual in powerBI

Re: Truck Visual in powerBI

Re: Truck Visual in powerBI