Incorrect GrantedQueryMemory(KB) Value on SQL Performance Dashboard or SSMS17.9
The inbuilt SQL Dashboard within newer versions of SSMS displays report for GrantedQueryMemory(KB) column for current request sub report. The value displays the wrong number as output displayed is in bytes while column says KB.
I have verified using the dmv "sys.dm_exec_query_stats" which lists this number in no.of pages which later is converted to KB
When checking within rdl file we can see that conversion is made with expression as =8192 * Fields!granted_query_memory.value which gets this value in bytes.
Therefore we might need to change that expression to = 8 * Fields!granted_query_memory.value
Please, install the latest version of SSMS (18.2+) which has the fix for this issue.