line graph

[Anonymous]

hi 

i want to show the data of in 2 axis line graph

but for one axis it is taking total call no 

how can i display both the axis data

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, you want to show the data of [Hour] in 2 axis line graph. I’ve downloaded your sample pbix file. I think you can give a relationship to the two tables which has “Both” filter direction, like this:

And you can get what you want, like this:

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[negi007]

@Anonymous In case you wish to have a line chart with dual axis. You can alwasy use the secondary axis where you can put the second value like below

In case you are using the same column for both the axis then i suggest you to create two seperate measures and then use in primary and secondary axis.

let me know if you need any other help. thanks

[Anonymous]

Hi negi

i was trying to display 2 different months calls data which is present in 2 columns

[negi007]

@Anonymous In this case, I suggest you to do the below things

1. Create a date table (use date from here in the x-axis)

2. Link your date table to Table 2 (Date column1)

3.  Link your date table to Table 2 (Date column2)

4. create your measure for second relationship use it in the secondary axis

Since you can have only one active relationship between two tables, your secondary relationship between table1 and table2 (date column2) will have inactive relationship. You wlll have to create one measure for date column2 that will use your inactive relationship

Measure = CALCULATE(sum(xyz),USERELATIONSHIP('Calendar'[Date],table2[Date2])))

if any issue, please share your powerbi file

[Anonymous]

hi negi

could you plz help me

https://drive.google.com/file/d/1o-P8cqQtnkd8dbqevu6gYZhylc2Ay__8/view?usp=sharing

[PhilipTreacy]

@Anonymous 

It's not entirely clear what you are doing - please supply a PBIX file with this data.  Where have you placed Call No?  It's being aggregated by SUM hence the same 1373 value.

Phil