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.
I have three different herirarichal slicers. Each has a coulmn and semi column on whose basis data is filtered in the graph.
Now I also have to add a data table to the mix, but the two columns are the common entity amongst the two., As such when I'm trying to create a realtiomship between those two, Power BI throws an error saying that one or more column needs to unique.
I'm not sure which direction I should be proceeding.
Please help
End Goal: to haver both the table and graph controlled from the same slicers.
Solved! Go to Solution.
Hi @Anonymous,
You need to create a Dimension table with unique ID's from the column that are common to both tables and then make the relationship between the two originals tables trhough this new table.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
You need to create a Dimension table with unique ID's from the column that are common to both tables and then make the relationship between the two originals tables trhough this new table.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |