Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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  
Need Help
Show and Tell
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi negi

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

negi007's avatar
negi007
Community Champion
5 years ago

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