Forum Discussion
line graph
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
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.
6 Replies
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 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
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
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.
