Forum Discussion

LFM's avatar
LFM
Icon for Helper III rankHelper III
2 years 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 sh...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years 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.

Anonymous's avatar
Anonymous
Not applicable
2 years 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.