Forum Discussion
Truck Visual in powerBI
Thanks that did work. However I was able to get the exact visual using infographic designer.
hi, can you tell me method
- prv_14012 years ago
Helper I
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 this2. 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 colouricon 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