Paginated report printing Icons

[Anonymous]

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

[Markzolotoy]

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

[DavisBI]

Hi, @Anonymous ,

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!

[Anonymous]

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

[AbhiSSRS]

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 . 

[DavisBI]

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