Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

@Please Help
@report server

5 Replies

  • DavisBI's avatar
    DavisBI
    Icon for Solution Specialist rankSolution Specialist
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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



      • DavisBI's avatar
        DavisBI
        Icon for Solution Specialist rankSolution Specialist
        5 years ago

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