Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I'm using this tutorial with SQL 2014 and AdventureWorks Database
I did exactly as it says on the tutorial, but when trying to create the chart, I click the Full Name and it shows a list of names and when I click on the 3 measures, sum, avg and count, it sums everything instead of showing it per person.
It should look like the first image, but it's showing as the second one
Solved! Go to Solution.
I figured what the problem was, on SalesPersonID, the column had only null values, I was meant to exclude them, but instead I selected all NULLs, so that's why the relationship wasn't working, I have excluded the NULLs and left all others and it's now working as it should.
Thank you all for your time in helping me out on this.
Have you joined the sales table to the customer table using the customer ID, and then placed the customer name from the customer table into your matrix on the rows?
The link with the tutorial is: https://www.simple-talk.com/sql/reporting-services/working-with-sql-server-data-in-power-bi-desktop/
So are you wanting to see sales rep names in your visualisations? I can't tell from the image of the model if the sales rep table is correctly joined to the sales table. I suggest putting salesrep[fullname] on rows and then sales[territory id] beneath it on rows. If the first level is blank but you see all the data at the second level, then your columns are not matching for some reason. Maybe it is the wrong column.
I figured what the problem was, on SalesPersonID, the column had only null values, I was meant to exclude them, but instead I selected all NULLs, so that's why the relationship wasn't working, I have excluded the NULLs and left all others and it's now working as it should.
Thank you all for your time in helping me out on this.
Can you post the formula for those 3 measures.
Sorry, not sure your link came through or some thing, to which tutorial are you referring?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |