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

Hi EaglesTony 

Based on the sample data you provide, you can refer to the following measures (if there is less data).

Measure = var a="Green"
var b="Yellow"
var c="Red"
var _avalue=LOOKUPVALUE('Table'[Column2],'Table'[Column1],a)
var _bvalue=LOOKUPVALUE('Table'[Column2],'Table'[Column1],b)
var _cvalue=LOOKUPVALUE('Table'[Column2],'Table'[Column1],c)
return "Total"&" "&a&":"&" "&_avalue&UNICHAR(10)&
"Total"&" "&b&":"&" "&_bvalue&UNICHAR(10)&
"Total"&" "&c&":"&" "&_cvalue

Then put the measure to the card visual

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.