Forum Discussion

sah259's avatar
sah259
Frequent Visitor
8 years ago

Combining two tables into one graphic

I have two different tables. Both have the variable "Day of Week". I want my x-axis to be categorical: Day of Week. I want one variable from one table and one from the other as my values. Can I do this?

 

I am in direct query so my DAX is very limited (and we want high performance, so we do not want to override that) and I cannot create any new tables in order to link things together. Also neither of my "Day of Week" columns has unique values, so I cannot make a relationship between them (even though they are the same variable). 

 

Any ideas how I can achieve this? 

 

Thanks in advance. 

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi sah259,

    After research and test, we can't add the values from two unrelated tables  in same x_axis. It will return the following errors.


    Best Regards,
    Angelia