Forum Discussion
Visual object created according to their sizes
Dear all,
I am preparing report that contains information regarding usage of consumables by warehouse. I ahve a table with bags dimensions and I would like to include some kind of visual objet that would correspond to size of each cosumable so it would be easier to analize the report. Is there any way to make it in Power BI?
7 Replies
- Fowmy
Super User
katerinabartosh
If you want to add a new column then create columns as follows: I used Windows + . in the keyboard to bring up the emojis and select the relevant shape.
New Column = SIWITH ( TABLE[SIZE ] , 350 , "◾", 500 , "◼" )You try more emojis from: https://unicode.org/emoji/charts/full-emoji-list.html
many thanks, this could be a part of my solution, but my initial idea was to see if is it possible to create icon or visual object according to the dimensions in the table, for example, for the B-1 S plastic bag to create visual objet with corresponding dimensions: 365/290/1 o just with 2 dimensiones 365/290.
v-henryk-mstfCommunity Support
Hi katerinabartosh ,
According to your description, my suggestion is to try to use the conditional formatting function to set icons according to different conditions for easy viewing.
related blog link:
Conditional Formatting Using Icons In Power BI - Excelerator BI
Or you can add emoticons by creating columns, refer to the following:
Column = UNICHAR(128512+'Table'[Value])related blog link:
How to Add Emojis to a Power BI Report | BI Elite
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi, thanks for the idea, but it doesn´t solve 100% my problem. My idea was to see if is it possible to create icon or visual object according to the dimensions in the table, for example, for the B-1 S plastic bag to create visual objet with corresponding dimensions: 365/290/1 o just with 2 dimensiones 365/290.
- v-henryk-mstf
Hi katerinabartosh ,
I guess such a display meets what you need.
Col_icon = 'Table'[Largo] & "/" & 'Table'[Altura] & "/" & 'Table'[Ancho]If you understand the error, I hope you show the screenshot of the result you expect through the drawing board, I will answer for you as soon as possible.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
