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 🙂
Hi Ross,
Many thanks. I understand your point but if you notice in my DAX code, there is only one item labeled as '3-6 Months'. If I was using the same condition for more items, I could have used AND operator but that is not the case here.
There must be more going on than is shown in your screenshots. What other fields/measures are used here? Is there a legend turned on?
Hi Ross,
Days Overdue is a calculated column in Power Query based upon Expiry Date's difference from Today's date. Then I created Overdue Status column based upon the value of 'Days Overdue' using a Switch statement in DAX. Does this help?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 🙂