Forum Discussion

Irwin's avatar
Irwin
Icon for Helper IV rankHelper IV
5 years ago
Solved

Import excel table with dynamic images

Hey everybody,   I am an absolute beginner at PowerBi. I have made an excel table (would love to attach but forum wont let me), wherein you can select 3 values. Theses 3 values then translate to an...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Irwin ,

     

    Create 2 measures as below:

    Measure_output1 = 
IF(ISFILTERED(Table2[Column1]),
SWITCH(SELECTEDVALUE(Table2[Column1]),
"Happy",
CALCULATE(MAX('Table1'[Output 1]),FILTER('Table1','Table1'[Output 1]="😊")),
"Medium",
CALCULATE(MAX('Table1'[Output 1]),FILTER('Table1','Table1'[Output 1]="🤔")),
"Sad",
CALCULATE(MAX('Table1'[Output 1]),FILTER('Table1','Table1'[Output 1]="😢"))),
CALCULATE(MAX('Table1'[Output 1]),FILTER('Table1','Table1'[A]=SELECTEDVALUE(Table1[A]))))
    Measure_output2 = 
IF(ISFILTERED(Table2[Column1]),
SWITCH(SELECTEDVALUE(Table2[Column1]),
"Happy",
CALCULATE(MAX('Table1'[Output 2]),FILTER('Table1','Table1'[Output 2]="😊")),
"Medium",
CALCULATE(MAX('Table1'[Output 2]),FILTER('Table1','Table1'[Output 2]="🤔")),
"Sad",
CALCULATE(MAX('Table1'[Output 2]),FILTER('Table1','Table1'[Output 2]="😢"))),
CALCULATE(MAX('Table1'[Output 1]),FILTER('Table1','Table1'[A]=SELECTEDVALUE(Table1[A]))))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

Irwin's avatar
Irwin
Icon for Helper IV rankHelper IV
5 years ago

Thank you. 

 

So this means I can still import the dynamic values (1,2,3) and then create the image display in PowerBi itself?

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi  Irwin ï¼Œ

     

    Not sure whether I understand correctly. Coud you pls attach some screenshots to make your requirement more clear?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

    • Irwin's avatar
      Irwin
      Icon for Helper IV rankHelper IV
      5 years ago

      Sure.

       

      I think most of the problem stems from me being super new to all of this.
      The below scren is what I have made in excel. When I change a value (sad/medium/happy... could as well be 1,2,3) the smiley changes correspondingly. I would like to be able to change the value (sad/medium/happy) in excel and  then the smiley table would import this value in PowerBi.

       

      I now realize that I need to create the value to image part inside powerbi, however, watching tutorials have not quite equiped me to do so yet on my own 😉
      Any help is appreciated! 

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Irwin ,

        First create dim table as below:

        Then create 2 measures as below:

        Measure_emoji1 = 
SWITCH(SELECTEDVALUE('dim table'[category]),
"happy",
CALCULATE(MAX('Table'[emoj 1]),FILTER('Table','Table'[emoj 1]=UNICHAR("128512"))),
"angry",
CALCULATE(MAX('Table'[emoj 1]),FILTER('Table','Table'[emoj 1]=UNICHAR("128520"))))
        Measure_emoji2 = 
SWITCH(SELECTEDVALUE('dim table'[category]),
"happy",
CALCULATE(MAX('Table'[emoj 2]),FILTER('Table','Table'[emoj 2]=UNICHAR("128512"))),
"angry",
CALCULATE(MAX('Table'[emoj 2]),FILTER('Table','Table'[emoj 2]=UNICHAR("128520"))))

        And you will see:

        For the unichar of emoji,see below for reference:

        https://powerbidocs.com/2020/06/08/how-to-use-emojis-emotions-on-power-bi/

         

        My sample .pbix file is attached,you may turn to it if needed.

         

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!