Data type change in columns from the Parameter table

[rosacyw]

Hey there, I would like some help on the column settings of the parameter table. I now have a visual table contains columns (with a data type as Percentage) from a parameter table, where the columns will be displayed by users selection on a slicer. There are also some other columns that are not from the parameter table. When I added the Total row by "Totals" in the visualization panel, the total numbers of most columns were displayed, except for the ones that have a data type that is not numeric and the ones that comes from the parameter table. Could you help me identify why there are missing total values in the Total rows and how to fix it? Is the data type of the columns changed after getting it through the parameter table?

Thanks!

[Ritaf1983]

Hi @rosacyw 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523