How to format a numeric parameter value (eg:Opening Balance) as currency field in Quick Sight Narrative?
Hi @BinuVarghese and welcome to the Quick Sight community!
So in terms of handling the format of a number, this would be done through the actual field that’s presenting the values.
So based on which field is being handled by your parameter, select the ellipses (3 dots) next to the field name and select Currency from the ‘show as’ section.
One note here, if you’d like the value to show as currency throughout your entire analysis, select the field from the ‘Dataset’ column all the way to the left. If you’d just like to change the value to show currency only for that visual, change it on the field within the visual’s field well.
Let me know if you have any additional questions or if this works for your case
Thank you for your response. My actual issue is how to directly display the parameter value in the insight (narrative) as currency. If I simply reference ${parameter1} in the insight narrative, I cannot apply any formatting to it. Please let me know if you need further clarification.
By the way, I use these parameters as user inputs since they are not coming from any data sources.
Hi @BinuVarghese,
Understood, thank you for the additional information. Unfortunately there’s no feature that allows you to set this though; you could try putting a currency symbol outside the parameter reference so that it’s hardcoded into your narrative. That would be the only way to work around since it’s a user input.
Hi @Brett
Thank you for your response. I created a workaround by writing a SELECT statement with a list of fields mapped to parameters and then used UNION ALL with the dataset’s SQL statement. This way, I was able to easily add it to the narrative and apply formatting. thanks
