Problems with the X-axis.

[joselopez]

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).

Already relationships in relationship manager img1 img2

[AllisonKennedy]

@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]

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]

@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