Column chart bars are misbehaving

Hi Tsheps 

The chart itself is probably not misbehaving. It is displaying additional distinct values that now exist in the data.

In Figure 2, values such as 100000000 and 100000001 appear on the X-axis. These look like internal Dataverse Choice/Option Set IDs rather than the corresponding display labels.

I would recommend:

Use Show as a table or export the visual data and locate the records containing these numeric values.
Check whether the visual axis uses the Choice name/label column rather than the numeric Choice value column. With the Dataverse connector, these are normally returned as separate fields.
If the survey columns were unpivoted, verify that the label columns were selected before the unpivot operation.
Check the Power Apps submission logic to determine why some newer records may have stored the internal Choice value instead of its label.

The extra bars are therefore being generated because Power BI considers the labels and numeric codes to be different response categories.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.