Dual Axis Graph with Common X Axis

[Alsabar]

Really struggling with, what I thought was, a relatively simple task displaying two columns (or lines) on the same visual with a common x-axis. As you can see from the screenshot I have a very simple table with 20 rows and 3 columns (ResponseID text, B1 int, and C1 int). I can count the numbers of 1's, 2's, 3's etc. in B1 and display that (see 1st graph) and I can do the same with C1 (see 2nd graph) but what I want to do is overlay the responses of the 2nd graph with the responses of the 1st graph with a common x-axis (whole numbers 1-7). When I try to do this I can't make the x-axis work such that I just get a 1-7 and the two scores. I think what I need to do is create a new table of Score Options (i.e. 1-7) and use that for the x-axis but can't work out how to make it work if that makes sense. Any help provided would be much appreciated.

[amitchandak · Accepted solution]

@Alsabar , Assume B1, C1 are columns, Create a new table with all int values and join with both B1 and C1.  One in will inactive use userelation to create a measure.

Use this new table on-axis

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

how to get that table

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

[Alsabar]

Just to say a huge thank you for your response. Whilst I had got the idea of creating a new table, I would NEVER have figured out the UseRelationship function.