Forum Discussion
Convert matrix table to clustered column chart
You can either:
a) Change the field type in Power Query or table view to whole number
b) if you need the values as text for other purposes, you can convert the text field to a number using a measure:
Text as number measure = VALUE(MAX('Table'[Filed as text]))
Hi johncolley , yes that is exactly the result I'm trying to acheive! When I try to convert my matrix to a clustered column chart, the target values move to the tooltips section. When I try to move them to the "values" section, that is when it aggregates to show the count of the values.
I have two seperate columns for these target values and currently set up as "text" data type.
Community ChampionYou can either:
a) Change the field type in Power Query or table view to whole number
b) if you need the values as text for other purposes, you can convert the text field to a number using a measure:
Text as number measure =
VALUE(MAX('Table'[Filed as text]))
Thank you! That worked perfectly. I had tried to change the data type to a whole number previously in my data table, but I guess I had to change it directly from power query.