Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I have a problem with table visualisation.
My model and data set in simplified version is:
I have three tables:
Tickets - which contain ticket number and recipient columns
Assets - which contain s/n. model and user name columns
Employees - wchich contain employee name, supervisor name
All tickets have a recipient, and all employees have supervisior, but not every s/n and model (they are always together) have user name. So visualisation should always show ticket, recipient and supervisor, and sometimes s/n and model when user (recipient) have it.
recipient name, user name and supervisor name means in fact the same so the tables are connected in that way:
(all relationships are many to many and bi directional filtering)
I made a table visualisation
P.A. and H.R. do not have any assets, but for sure have supervisor
I do not understand why it do not shows supervisor name, even when it takes and connects right rows from all databases.
When I change the order of columns in visualisation it shows correctly...
Can you please describe me why it behave like this?
Thanks and regards!
Hi @Anonymous ,
Click the drop down arrow of "Supervisor name" in the above 2 orders to check whether they have the same aggregation.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Your assets and your employees are dimensions. Your tickets are facts. Create a data model where both assets and employees have a 1:many relationship with tickets, with single direction. That is called a star schema.
User | Count |
---|---|
73 | |
70 | |
38 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
43 | |
42 |