Forum Discussion

aar0n's avatar
aar0n
Advocate II
8 years ago

d3 Line graph dual y-axis

The following code compiles, but doesn't render a graph. Not sure why exactly it isnt working in power bi....   i am using an input of "Date", "Value1", "Value2". i am trying to plot date on x-axi...
Need Help
Tips and Tricks
Tutorial Requests
jppp's avatar
jppp
Continued Contributor
8 years ago

I managed to get the code working and basically the trick is in how the data is presented to and used by D3js.
In this case the date column: I have kept it as a string, e.g. '26-Mar-18' and add a derived column, convert as a date type and use that for the 'sort-by' column.

After that the line d3.time.format("%d-%b-%y").parse; will correctly parse the column to dates that can be used by the d3js axis.

 

If you need some more explanation; I got a PBIX file that I can share if needed.

 

-JP

 

sriksrin's avatar
sriksrin
Frequent Visitor
8 years ago

Hi JP,

 

 While i am trying what you have said, it would really be very helpful to share the pbix file.

 

Thanks

Srikanth