Charticulator - Tick Formatting

[mahoneypat]

I'm trying to change the format of the X axis labels for date values in the example chart below. I've read in the Charticulator documentation that d3 syntax is needed (e.g., %Y-%m-%d). I've tried several variations but haven't found the right syntax yet. Can someone provide an example of what to put in the Tick Data and/or Tick Format fields to get yyyy-MM-dd, for example?

@Burningsuit 

Pat

[Burningsuit]

HI @mahoneypat 

d3-format is for formatting numerics, not dates. So you won't be able to format it with Tick Format. Charticulator gives you a default continuous axis, just like Power BI does. If you just want to not show the time element, reformat the data type in Power BI from "Datetime" to "Date".

Hope this helps

Stuart

PS. Our book "Introducing Charticulator for Power BI: Design Vibrant and Customized Visual Representations of Data" should be out soon, hopefully before then end of February, and gives a lot more detail.

[mahoneypat]

Congratulations on your book. Your blog articles were helpful, so I assume the book will be too. The column (and measure) are already Date format. The issue is that my example has 6 days/rows but the chart puts a minimum of 10 ticks (so it needs to put time values too). It would be good to know if there is a way to specify the # of ticks, but, in practice, I would have more than 10 rows. D3 does have syntax for date values, so it looks possible.

Pat