Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Community, I desparately need your help.
Here's what I have and what I'm trying to do (but can't figure out):
Here's my problem:
When using the slicer titled "Dealer", both line charts will correctly switch between Bob & Joe to correctly toggle between the corresponding dealers. The slicer titled "Condition" will NOT do the same. When I select any 1 of the 4 variables, only the "Units" line chart (top chart) correctly changes and it has no effect on the "Price" line chart (bottom chart).
Here's my data and relationship setup:
I have 2 tables, each with 4 columns. 3 out of the 4 columns are identical. The difference is, 1 table is showing unit sales while the other has unit price as shown below. As you can also see, I've also established a relationship between the 2 tables via the column labeled "Dealer".
Based on google and BI forum searches, I've tried creating a new table called "top" as you can see above that contains the "dealer" & "condition" columns but as you can see, I'm still only able to create 1 active relationship only. I've also tried creating a new column using the concatenate function but that didn't work either. Of course, I won't rule out that I very well could have been doing these incorrectly.
How can I use the 2 slicers I have in my report to function correctly with the 2 line charts???????
Thank you in advance.
Hi, @bikerboy28
We suggest you use a star schema like below.
If you have a table pattern with loops like below. Cross filtering can create an ambiguous set of relationships. For instance, if you sum up a field from TableX and then choose to filter by a field on TableY, then it’s not clear how the filter should travel, through the top table or the bottom table.
We don't recommend you relate many-to-many dimension-type tables directly. When you have a many-to-many relationship between dimension-type tables, we provide the following guidance:
For further information, you may refer to Create and manage relationships in Power BI Desktop and Many-to-many relationship guidance .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@bikerboy28 , You join to have a problem. Make them a single direction and try.
If possible try to avoid one of the two joins top to price or sales to price
Hello
the idea of the data model is to try to make what you want to measure (fact table or fact table) surrounded by the attributes of the objects that have the measure (dimension table) and in or possible the dimension table only by pointing in direction to the fact table.
In your model it has address on both sides, and from what you review the PBI does not let you use only one address. This is generally because there is no single union (a fact table field equal to the dimension table).
I give you an example, here I have 2 tables, that to relate them you must not only use the sku or the center, but both concatenated, otherwise the combinations are multiplied
After concatenation I perform the union by this new field. and I can already get an address in the relationship, because the union field has no repeat rows. If you joined it only by sku (assuming that the sku 1 exists in center A and B) then it could not be related from 1 to 1, but from * to * (many to a lot) because row values are repeated by the union field.
Seeing your model may be the problem, whether you don't have unique values for the union field so the relationship from many to many is the only viable one.
You tell me and we check.
Best regards.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |