Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |