Forum Discussion
Helper IILine and stacked column chart - last x-axis value missing
Hello,
I have a Line and stacked column chart that displays Count on the Stack and Avg Discount % on the line for each week (the hierarchy is placed for FY, Month, Weekending date). For some reason, it does not display the last weekending date every time. Below is a screenshot of the same.
I just updated the Power BI desktop version and tested too but the issue still remains. Please advise.
Thank You,
Harisha
3 Replies
- Phil_Seamark
Microsoft Employee
Hi hmokkapati,
It looks like it can't find a date for those items. What table are you using to get the field for the axis and what table are your measures computed over?
- dkay84_PowerBI
To check what Phil_Seamark is referring to, try adding the date field (the same one you are using for the x axis) to the visual level filters and see if there is a "Blank" value. If so, try selecting all but the blank value and see if that unlabeled column dissapears.
v-sihou-msftIf your fact data (Count on Stack, Avg Discount %) and date are not from same table, you need to check if the fact table are fully mapping each item in the Date dimension table. If not, it will generate blank items for Date.
Regards,
