Forum Discussion

malpani's avatar
malpani
Icon for Helper II rankHelper II
2 years ago

Deneb Visual Vegalite - Duplicate labels (Month-Year) on X axis

Hello Experts,  I am creating a PBI custom visual using Deneb Vegalite and I am facing problem with X axis labels. Visual is shown in the attched image.     On X axis, I have Date type colu...
giammariam's avatar
giammariam
Icon for Solution Sage rankSolution Sage
2 years ago

Hi malpani, thanks for the .pbix. For both of your x-axes keep the type as temporal and make sure you set 

"timeUnit": "yearmonth",

 


Going by your formatting, I'm assuming you only want the month and year. This should get rid of the duplicates.

If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.




  • malpani's avatar
    malpani
    Icon for Helper II rankHelper II
    2 years ago

    Hi 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.

    • malpani's avatar
      malpani
      Icon for Helper II rankHelper II
      2 years ago

      Hi 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's avatar
        giammariam
        Icon for Solution Sage rankSolution Sage
        2 years ago

        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.