Forum Discussion

joselopez's avatar
joselopez
Frequent Visitor
5 years ago

Problems with the X-axis.

Hello Community! I want to plot different points that have equal values on the x-axis. But the curve values not associated with that x-axis (image 2) are plotted differently (image 1). Alre...
AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

joselopez  Please can you share the screenshot of relationships in the model view (the one with the tables and lines, not just relationship manager). 

Also, please can you elaborate on your desired result? What should the image1 look like? 

  • joselopez's avatar
    joselopez
    Frequent Visitor
    5 years ago

    Hi Allison...

     

    Finally, I created an auxiliary variable which contains the x-axis (km), so there are no more problems with graphing (Fig1) (which is the expected result)..... Now the problem is as follows.

    For the filter I need to Filter for ring 1-2 and 3. (Fig 2 and 3).

    In the figure 3 you can see that the auxiliary variable of ring lets me make the connection with A1 historical... but if I want to make the relation with any other ring Ex: A3 historical it does not leave me.

    I don't know how to solve this.

    Thanks a lot!

    Fig 1Fig 2Fig 3

    • AllisonKennedy's avatar
      AllisonKennedy
      Community Champion
      5 years ago

      joselopez 

       

      Power BI only allows one relationship between any two tables. You may be able to append all historical tables into one table? 

       

      Your data format also looks like it could benefit from an unpivot of columns 1-8, but I'm not certain without know a lot more about your data. You might want to follow a similar process to what I have discussed in my Survey Says webinar. Even though it's not survey data, you have readings for different numbers (1-8) that need to be unpivoted. Click the Watch Now Survey Says button to find it: https://www.excelwithallison.com/MCT/news#h.p_NkgcNxVFFYaS