I'm trying to create a very simple graph from data pulled in from Excel (in Power BI app). I have created the graph before, but now for whatever reason I am getting the following "Count of" or "Count (distinct)" as my only options which is not what I want to depict in the graph.
Usually I can select from "Sum", "Average" etc, but not for this data.
Check the Modeling tab in the ribbon and look at the data type there. Or check the data type of the column in the query editor.