Forum Discussion

katerinabartosh's avatar
katerinabartosh
Regular Visitor
5 years ago

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 th...
Need Help
Tips and Tricks
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

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.

  • katerinabartosh's avatar
    katerinabartosh
    Regular Visitor
    5 years ago

    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's avatar
      v-henryk-mstf
      Icon for Community Support rankCommunity Support
      5 years ago

      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.

      • katerinabartosh's avatar
        katerinabartosh
        Regular Visitor
        5 years ago

        Hi Henry, I guess i have not explained myself correctly, as final result i would like to have visual form with dimensiones from the table, so in this example it would be box with large of 365 mm, widht 290 mm and height 1 mm. But I guess is imposible to represent it like this in visualization, it is better to create these objects outside of Power BI, am i right?