Forum Discussion
Helper IIDeneb Visual Vegalite - Duplicate labels (Month-Year) on X axis
Helper IIHi giammariam
Thanks for your help.
But I expect the marks shown by date and axis labels by unique Month-Year.
As you see, if you change both X axis encoding to temporal, marks overlap with each other.
We had two marks in July C3 and C5 but with temporal they overlap with each other which is not readable.
So, I would like to keep the same position for C3 and C5 by date in a month but when it comes to label show only once per month.
Helper IIHi giammariam : Do you think it is possible to have month-Year on X axis but marks shown by dates.
What if we calculate Month-Year column Date column Power Query or by DAX and then use that column ?
- giammariam
Solution Sage
malpani, apologies, but I'm not fully comprehending what your end goal is. However, I have a sneaking suspicion that your solution will involve resolving the scales. Read more about resolve here.
- malpani
giammariam :
I have milestones based on dates, so in same month it is possile to have multiple milestones.
When I am trying to show Month-Year on X axis as labels using timeunit monthyear and type temporal, all milestones (marks) which belong to the same month overlap each other.To make all milestones (marks) visile and do not overlap, I am using date to position marks but as a consecuence of that it show too many repeated labels for Month-Year meaning it shows label for each mark.
Instead even if there are milstones (marks) distriuted by date in same month, I want to show them at different position but on X axis, I want to show label once for each month-year.- giammariam
Thanks for that malpani. I got closer, see here. However, with the data that you provided, you can see that the milestones overlap when there are more than 2 in a given month.
An alternative way that this may be able to be handled is that you facet the data so that each column is a month-year. Then within each facet you could have the milestones laid out sequentially. To do this though, you'd want to have your dataset include rows for month-years that have no milestones (e.g. February - June, plus September in this dataset) so they show in the facet. If you're able to set up your dataset to include these additional rows, I can give this a shot.
