Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
prv_1401
Helper I
Helper I

Truck Visual in powerBI

IMG_20220906_004619.jpg

 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 

4 REPLIES 4
lbendlin
Super User
Super User

here's one possible implementation

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

hi, can you tell me method

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

prv_1401_0-1709124865822.png

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.

prv_1401_1-1709125136094.png

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.

prv_1401_2-1709125176631.pngprv_1401_3-1709125191301.png

 

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.
prv_1401_4-1709125977282.pngprv_1401_5-1709125991301.png

 

Regards, 
Praveen




 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors