Forum Discussion

EaglesTony's avatar
EaglesTony
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

How do I show 2 columns in a query table in a text box instead of the table visual?

Hi,     I have the following in a table:   Green  50 Yellow  20 Red      100     I don't want to show this on the report as a table, but as text as such:   "Total Green: 50" "Total Yellow:...
Need Help
  • EaglesTony's avatar
    EaglesTony
    3 years ago
    The issue was the columns needed flipped around.

Measure = var a="Green" 
var b="Yellow"
 var c="Red" 
var _avalue =LOOKUPVALUE(Append1[Count],Append1[AgingDaysColor],a) 
var _bvalue=LOOKUPVALUE(Append1[Count],Append1[AgingDaysColor],b) 
var _cvalue=LOOKUPVALUE(Append1[Count],Append1[AgingDaysColor],c) 
return "Total"&" "&a&":"&" "&_avalue&UNICHAR(10)&
"Total"&" "&b&":"&" "&_bvalue&UNICHAR(10)&
"Total"&" "&c&":"&" "&_cvalue
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?