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.
Hi everybody.
I have a pretty basic question that I can't find the answer for. I have 2 tables. Let's just say the layout is the following:
table 1- Item, Nickname
table 2- Item, Condition, Quantity
What I want is to show Nickname and Condition by Quantity. I'm not sure how to get to this point in Desktop. If I had Nickname in table 2 I could do it by dragging and dropping, but that isn't the case.
Any help would be appreciated.
Edit: This would be a drill-down column. I don't know if that makes a difference.
Do you have a relationship between Table 1 and Table 2 based on "Item" columns? If so, you can essentially treat them as one big table (more or less)
Yes, I do have a relationship between them. How would I treat them as a table? And would this support the drill down feature?
So for example let's say table 2 now has "Manufacturer" added to it. Could I drill down to Manufacturer, then Nickname/Condition?
Hi @Anonymous,
If the tables contain the relation, you can directly drag the columns which you need to a table visual to display them.
Regards,
Xiaoxin Sheng
I'll keep trying to play around with this until I get it to work.
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 | |
100 | |
86 | |
64 |