Forum Discussion
Column chart bars are misbehaving
Good day. Can someone please help me figure out whey my report column bars are misbehaving.
The report source is a table that collects survey responses, and lives on PowerApps(Dataverse).
as shown in figure 1, both charts were behaving as per the survey questions.
Then in figure 2, extra bars starting forming out of nowhere, distorting the responses. There have been no changes made to the form, nor any changes to the columns in Dataverse.
Figure 1
Figure 2
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.
3 Replies
- Ritaf1983
Super User
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.
v-saisrao-msftCommunity Support
- v-saisrao-msft
Hi Tsheps,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.