Forum Discussion

CStillman's avatar
CStillman
Frequent Visitor
1 year ago
Solved

Dispaly SVG Image or Text Within Same Matrix Column

I have a DAX expression which renders a SVG image or displays a number depending on the scope of the row. I am able to get the number to display, but instead of the image displaying, the SVG markup gets displayed. InScope is categorized correctly as an Image URL and I am able to display only the image if I program my DAX expression as InScope = [BlueBox]. This tells me that the measure is defined and categorized correctly. I am scratching my head trying to get this to work. I know it shouldn't be this problematic. Any suggestions? TIA

 

Dax Expression:

InScope = IF ( AND ( ISINSCOPE('Employee'[Name]), [Assigned] = 1 ), [BlueBox] , [Assigned] )
 

Resulting Matrix (also showing that my SVG images do render correctly):

 

 

 

 

 
  • lbendlin's avatar
    lbendlin
    1 year ago

    You need to render your text via SVG as well.  You cannot mix column types.

3 Replies

    • CStillman's avatar
      CStillman
      Frequent Visitor

      Thanks for the reply lbendlin. How would adding more of the boilerplate code to the image help? I still don't think it would render correctly. As you can see, as it's currently defined, it renders fine when used on its own. It's the combination of displaying the image or text within the same column that is causing the problem.

       

      I now think it has more to do with displaying the value than displaying the image. I tweaked my expression, hard coding the value as a string. This changed the measures format from General to Text.

       

      InScope = IF (  AND (  ISINSCOPE('Head Count Combined'[PAYROLL_NAME]) , [Assigned New] = 1  ) , [BlueBox]  , "6" )
       
      Now the images display appropriately but the values don't (there should be a 6 at each placeholder).

       


       

      • lbendlin's avatar
        lbendlin
        Super User

        You need to render your text via SVG as well.  You cannot mix column types.