Forum Discussion
Solved
Numeric ID as Categorical Variable
I have an variable that's an integer identifier. I want a chart that displays the average of some other variable for each unique option of this ID variable. When I try and do this in Power BI, it jus...
I might be misunderstanding something here but I have no problems doing this. Both the columns are whole numbers. All I have to do is put on column in Axis and the other in Value and Power BI does the rest. Are you doing something different?
That's exactly what I'm doing too, I even recreated with some different variables to ensure it wasn't just something weird about that specific combination.
If it makes any difference, I'm connected via ODBC to a Postgres database.
This can happen if table relationships are involved and not configured exactly right. Are there any related tables? Can you share sample data and/or your .PBIX?
...And just saw you got it fixed. Good news.