User Profile
ArtisanAmbrosia
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Re: Concatenate 3 column values as icons
I appreciate your reply and time. It seems you've primarily repeated the DAX I already wrote and I don't understand the need for the first Combined Icons measure if I use the 2nd Combined Icons measure in the matrix. The issue of conditionally formatting each icon within the concatenated measure is still not solved. What "trick" would assign colors to each icon conditionally? Your last statement is the part I need to solve for: "Make sure to apply the conditional formatting rules properly to reflect the correct colors in your matrix visual."Re: Concatenate 3 column values as icons
Thank you for the blog. I would love to be able to conditionally format but it's not working with my concatenated column. I've been messing around with different DAX calculations for conditional formatting that would display a different icon for each concatenated column's results within the same column. I tried using gray unicode triangles instead to apply color formatting to, but it would only change the color of the 3rd icon rather than all 3. $ to Pace Format = SWITCH(TRUE(), CONTAINSSTRING([Combined Icons], UNICHAR(9650)), UNICHAR(9650) = "#3F9C35", CONTAINSSTRING([Combined Icons], UNICHAR(9660)), UNICHAR(9660) = "#E40046", BLANK())Concatenate 3 column values as icons
I am tracking Sales to Pace (target) and need to display a matrix column with past 3 month's results as 3 concatenated icons. Example with : Here's my base DAX I've trying different methods with: $ to Pace Cumulative = 'DAX Measures'[Created] - 'DAX Measures'[Combined Pace Cumulative Table] $ to Pace LCM = CALCULATE([$ to Pace Cumulative], 'Date Table'[CurrMonthOffset] = -1) $ to Pace LCM-2 = CALCULATE([$ to Pace Cumulative], 'Date Table'[CurrMonthOffset] = -2) $ to Pace LCM-3 = CALCULATE([$ to Pace Cumulative], 'Date Table'[CurrMonthOffset] = -3) $ to Pace LCM Icon = SWITCH(TRUE(), 'DAX Measures'[$ to Pace LCM] > 0, UNICHAR(9650), 'DAX Measures'[$ to Pace LCM] < 0, UNICHAR(9660), BLANK()) $ to Pace LCM-2 Icon = IF('DAX Measures'[$ to Pace LCM-2] > 0, "✅", "❌") $ to Pace LCM-3 Icon = IF('DAX Measures'[$ to Pace LCM-3] > 0, "🟢", "⭕") Combined Icons = [$ to Pace LCM-3 Icon] & " " & [$ to Pace LCM-2 Icon] & " " & [$ to Pace LCM Icon] The [Combined Icons] column is [Last 3 Months] in example matrix. Since I'm trying to represent the value of [$ to Pace Cumulative] as an icon only, I haven't been able to come up with a measure for conditional formatting that correctly designates a color for the unicode triangles or an icon for the values of concatenated measures. Ideally, I want to display these native PBI icons for above 0 and below 0: However, the following DAX doesn't work: $ to Pace LCM-2 Icon = IF('DAX Measures'[$ to Pace LCM-2] > 0, "TriangleHigh", "TriangleLow") I also couldn't get image URLs to work in this measure. Any idea how I can display the [Last 3 Months] column using the above native Power BI green and red triangles?
