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
v-viig's avatar
v-viig
Community Champion
8 years ago

jppp Can you help with this issue? It seems devs use D3.JS visual.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

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

 

  • aar0n's avatar
    aar0n
    Advocate II
    8 years ago

    i would really appreciate if you could share the file! 

     

    Thanks for the help!!

     

  • jppp's avatar
    jppp
    Continued Contributor
    8 years ago

    You should be able to download it here.

     

    If you have questions, feel free.

  • 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

  • v-viig's avatar
    v-viig
    Community Champion
    8 years ago

    PBIX has been attached by Jan Pieter. See link above.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

  • sriksrin's avatar
    sriksrin
    Frequent Visitor
    8 years ago

    Thanks jppp for sharing the pbix file. I am still puzzled as the new duplicate column didnot change any data after been applied to sort. Can u share some more details on the fix.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Can you reshare PBIX file ? cause the link you posted is no longer available.