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!

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!

 

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

Hi Kelly,

 

I have now had proper time to read your excellent feedback and mess around with it myself. I think that the main reason I cannot (could not?) get this to work is my lack of basic understanding. I am very much trying to work on that! 🙂

 

I have now managed to contruct something that I am quite satisfied with:

 

 

however, I cannot make it display correctly in the report. It just shows the first 5 rows.... why? 

 

Thank you for any assistance.