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