Forum Discussion
Bar chart showing same category twice erroneously
Hi Ross,
I found the answer. I had a separate column created using DAX called "Overdue Rank" which was used to sort the items of "Overdue Status" column in a specific order in the bar chart. apart from the ranking, both Overdue columns were based upon the same DAX coding as pasted in my original message. So here is what happened - I removed a few conditions from the switch formula of "Overdue Status" column (like when Days overdue are between 0 to 7, show status as "Due in 1 Week". However, I forgot to change the "Overdue Rank" column accordingly. Just when you mentioned there must be more going on here, I checked again and figured out. Thank you very much 🙂
That tells us how the column containing "Overdue Status" has come about, which on its own shouldn't cause whats occuring in the graph. What else is included in this graph, its a count of something. Does the visual have a legend? Does the issue still occur if you save and quit and reopen Power BI?
Hi Ross,
I found the answer. I had a separate column created using DAX called "Overdue Rank" which was used to sort the items of "Overdue Status" column in a specific order in the bar chart. apart from the ranking, both Overdue columns were based upon the same DAX coding as pasted in my original message. So here is what happened - I removed a few conditions from the switch formula of "Overdue Status" column (like when Days overdue are between 0 to 7, show status as "Due in 1 Week". However, I forgot to change the "Overdue Rank" column accordingly. Just when you mentioned there must be more going on here, I checked again and figured out. Thank you very much 🙂