Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
kp123
New Member

Image Pro by Cloudscope & Filtering

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!

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Hi @kp123 ,

 

Based on your description, I have created a simple sample:

vjianbolimsft_0-1666325297089.png

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)

vjianbolimsft_2-1666325546393.png

Then create a measure:

Measure = 
SWITCH(TRUE(),
ISFILTERED('Table'[AccountId]),SELECTEDVALUE('Table'[Show profile]),[Blank Value])

Final output:

vjianbolimsft_3-1666325656592.png

vjianbolimsft_4-1666325667077.png

vjianbolimsft_5-1666325679663.png

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.

View solution in original post

3 REPLIES 3
v-jianboli-msft
Community Support
Community Support

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.

v-jianboli-msft
Community Support
Community Support

Hi @kp123 ,

 

Based on your description, I have created a simple sample:

vjianbolimsft_0-1666325297089.png

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)

vjianbolimsft_2-1666325546393.png

Then create a measure:

Measure = 
SWITCH(TRUE(),
ISFILTERED('Table'[AccountId]),SELECTEDVALUE('Table'[Show profile]),[Blank Value])

Final output:

vjianbolimsft_3-1666325656592.png

vjianbolimsft_4-1666325667077.png

vjianbolimsft_5-1666325679663.png

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?

kp123_0-1668718445343.png

 

Thanks

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.