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.
My dataset is an Access file with two linked tables. In one table is the main data and a field "salesman" is a number from 1 to 12. In the second table is the salesman number (1 to 12) and their name.
I want to create a chart that is sales ($) by salesman. This is rather easy, but the x-axis shows the salesman number (1 to 12), not their name. How can I get it to display the name?
Thanks.
Solved! Go to Solution.
That's what I thought. It would show the names, but the sales numbers were wrong. I started to look at the tables' relationships and it turns out that when I brought the Access DB into PowerBI, it linked the wrong table fields together. Once I re-linked the correct fields, all is well.
Notageek
Hi @notageek,
You need to place the Salemans name from the second table on your x-axis if the table are linked in PBI should give you what you want.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThat's what I thought. It would show the names, but the sales numbers were wrong. I started to look at the tables' relationships and it turns out that when I brought the Access DB into PowerBI, it linked the wrong table fields together. Once I re-linked the correct fields, all is well.
Notageek
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |