Replace a value for an image in DAX measure
Hello all, I have the DAX below, which gives that red dot (it's just a letter 'o') when the growth is negative. Has Poor Course = VAR ThisAcademicYear = ( SELECTCOLUMNS ( TOPN ( 1, 'DWH Dim_Application_Date', 'DWH Dim_Application_Date'[Application Academic Year Desc], DESC ), "Application Academic Year Desc", 'DWH Dim_Application_Date'[Application Academic Year Desc] ) ) VAR LastAcademicYear = ( LEFT ( ThisAcademicYear, 4 ) - 1 & "/" & LEFT ( ThisAcademicYear, 4 ) ) VAR ApplicationsByCourse = ( SUMMARIZE ( 'DWH Fact_Course_Application', 'DWH Dim_Course'[Course Name], "Applications This Year", CALCULATE ( SUM ( 'DWH Fact_Course_Application'[Application Count] ), 'DWH Dim_Application_Date'[Application Academic Year Desc] = ThisAcademicYear ), "Applications Last Year", CALCULATE ( SUM ( 'DWH Fact_Course_Application'[Application Count] ), 'DWH Dim_Application_Date'[Application Academic Year Desc] = LastAcademicYear ) ) ) RETURN SELECTCOLUMNS ( TOPN ( 1, ApplicationsByCourse, IF ( DIVIDE ( [Applications YTD Current Year], [Applications Last Year YTD] ) - 1 < 0, 1, 0 ), DESC ), "isPoorPerformer", IF ( DIVIDE ( [Applications YTD Current Year], [Applications Last Year YTD] ) - 1 < 0, "o", "" )) My question is, how can replace the letter with an image? I have tried copy and paste the URL link on the measure, but it gives me a link address on the table rather than an image. Can you please advise? Many thanks, R.
