Forum Discussion
Helper IVImport 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 image (smileys). This is displayed on another page in a table.
Is it possible to import this table (as is) into powerbi? When I import the excel file it just shows data.
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,
KellyDid I answer your question? Mark my post as a solution!
11 Replies
- amitchandak
Super User
Irwin , Excel is only for data export. You can export ppt or pdf the display format.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
IrwinThank you.
So this means I can still import the dynamic values (1,2,3) and then create the image display in PowerBi itself?
- amitchandak
Irwin , You can import excel as data. Unichar and some other formats can be used to create images. You have a check that out
Unichar :
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
https://exceleratorbi.com.au/dax-unichar-function-power-bi/ - v-kelly-msft
Community Support
Hi Irwin ，
Not sure whether I understand correctly. Coud you pls attach some screenshots to make your requirement more clear?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- Irwin
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!
