Forum Discussion

LFM's avatar
LFM
Icon for Helper III rankHelper III
1 year ago
Solved

Multiple line graphs with different different columns for the x-axis

Hi. I want to make a duration curve graph. The graph should contain multiple lines that shows different spot prices on the y- axis. The different prices have different index values witch should be shown on the x-axis. I cannot put all columns with different prices with corresponding index values in the same graph as they will not match each other. Its not like when you have dates that would be similar for all the prices. Some of the data with spot prices with their indexes values are shown under. I want it to be shown in one graph with index values 0-8760 for all the prices on the x-axis. 

 

 

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi LFM ,

     

    According to your statement, I think your requirement is to show a line chart for different SPOT columns based on their Index columns.

    Here I suggest you to add a DimIndex table to help calculation.

    DimIndex = GENERATESERIES(0,8760,1)

    Due to there could only be one active relationships between two tables, you can try to create multiple inactive relationships and use USERELATIOHIPS() function in measure.

    Measures:

    M_SPOT = CALCULATE(SUM('Table'[SPOT]),USERELATIONSHIP('Table'[Index spot],DimIndex[Index]))
    M_SPOTNO1 = CALCULATE(SUM('Table'[SPOTNO1]),USERELATIONSHIP('Table'[Index SPOTNO1],DimIndex[Index]))

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    1 year ago

    LFM sorry I'm having hard time understanding your requirement, could you put it in excel and explain it what you are looking for, and share that file using onedrive/google drive.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi LFM ,

     

    According to your statement, I think your requirement is to show a line chart for different SPOT columns based on their Index columns.

    Here I suggest you to add a DimIndex table to help calculation.

    DimIndex = GENERATESERIES(0,8760,1)

    Due to there could only be one active relationships between two tables, you can try to create multiple inactive relationships and use USERELATIOHIPS() function in measure.

    Measures:

    M_SPOT = CALCULATE(SUM('Table'[SPOT]),USERELATIONSHIP('Table'[Index spot],DimIndex[Index]))
    M_SPOTNO1 = CALCULATE(SUM('Table'[SPOTNO1]),USERELATIONSHIP('Table'[Index SPOTNO1],DimIndex[Index]))

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.