Forum Discussion
Helper IIDeneb Visual Vegalite - Duplicate labels (Month-Year) on X axis
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 ?
Solution Sagemalpani, 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.