cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jishnu
Helper I
Helper I

Paginated report printing Icons

Hi Everyone, 

I'm stuck with a scenario where I need to print the matrix to a csv/ excel and one of the column is representing the base 64 icon which is using a dax calculation. The problem that I'm facing is when I try to export,  exporting to csv gives only the underlying base64 url instead of the icon. Have anyone faced this situation or can provide a help with this?

 

Regards,

Jishnu

5 REPLIES 5
Markzolotoy
Post Prodigy
Post Prodigy

@DavisBI Are you saying I can have an SVG image n Power BI paginated reports?

DavisBI
Super User I
Super User I

Hi, @jishnu ,

 

Paginated report can export the icon to excel file, but I don't think you're using paginated report, 

"csv/ excel ", " dax calculation", sounds like you're using Power BI Report that hosts on Power BI Report Server instead of paginated report, export image (including icon) is not supported for Power BI Report currently.

 

Mark this post as solution if this helps, thanks!

Hi @DavisBI ,

Thanks for the response and sorry for not making it clear. What you stated is correct, the report is not moved to paginated one, it is still under proposal and I'd like to know if there is a way to print icons if it is moved to the Paginated report. 
My current Power BI report has the following measure and showing it in a matrix visual against an availability and country dimensions:

 

Icon =
var sta =

min(StatusTable[StatusId])
return
switch(TRUE(),
sta = 1, "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='100' height='100' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='Blue-Gray' stroke-width='4' fill='#39424c' /> </svg>",
sta = 2, "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='100' height='100' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='lightgray' stroke-width='4' fill='#808080' /> </svg>",
sta = 3, "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='100' height='100' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='#00338d' stroke-width='4' fill='#005EB8' /> </svg>")

and when this matrix is printed, the exported one shows this value itself.

 

As you suggested, if I move to paginated report, what would be my expression? Also, is it printable?

 

Regards,

Jishnu



Yes! This is perfectly feasible in Paginated as whatever renders on rpeort would be rendered in your excel and PDF exports. Please go ahead with Paginated! Also Paginated supports many more print options than pbix . 

@jishnu  It's printable, but the SWITCH() function in Report Builder is a little bit different from DAX, you can refer to this document.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.