Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have created a dashboard where I can filter different manufacturing lines (with the Slicer) and the respective floor plan will display as an image (courtesy of "Image Pro by Clouscope"). It works just fine when I select one of the manufacturing lines in the slicer...but when nothing is selected, the "Image Pro" visual is displaying an image of a random floor plan...is it possible to display no image, or a blank image, when no manufacturing line is selected?
I am currently pulling data from an Access database. In the database I have a column where I paste the Base64 string. In the tables section of PowerBI, I set the data category for this column to be "Image Url". The "Image Pro" visual is using this Base64 string for the 'Image url'.
Thanks!
Solved! Go to Solution.
Hi @kp123 ,
Based on your description, I have created a simple sample:
First, create a Measure to display the image you want to display when nothing is selected(The DAX is the base64 code of the image)
Then create a measure:
Measure =
SWITCH(TRUE(),
ISFILTERED('Table'[AccountId]),SELECTEDVALUE('Table'[Show profile]),[Blank Value])
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kp123 ,
They are still essentially text, try putting them in quotation marks, like "your code"
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kp123 ,
Based on your description, I have created a simple sample:
First, create a Measure to display the image you want to display when nothing is selected(The DAX is the base64 code of the image)
Then create a measure:
Measure =
SWITCH(TRUE(),
ISFILTERED('Table'[AccountId]),SELECTEDVALUE('Table'[Show profile]),[Blank Value])
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Thanks so much for your response!
How did you create the measure for the "Blank Value"? When I create a measure, I am not able to change the data category to 'Image URL'.
I created a column in my data field for the blank value image but the base64 code that I enter does not work. Do you know why this may be?
Thanks
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |