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,
I have to Queries running in my Sales analisys Dashbord, one of the queries was cloned and I did add some new coolumns as well as some calculated columns, the issue and/ question I have is how I should related them and get them use the same slicers?
If I try to conect them them I many to many error is coming up, Any suggestion about the best way to handle multiple queries in the same Dashboard
Thanks
Rigo
Solved! Go to Solution.
You should create one or more new tables in your model containing the fields on which you want to slice. Each table should contain a column with unique values, that can be used to connect your original queries/tables. Like, if you have customer information in both tables, you will have a lot of duplicate data about these customers. Instead, create a separate customer data identified by customer number (in hope you have that, or something else that is unique - how else would you distinguish between customers?)
You can create these tables from your original queries by referencing them, keeping only the columns relevant to the new table, and remove duplicate rows (be sure to select all columns before adding that step).
You should create one or more new tables in your model containing the fields on which you want to slice. Each table should contain a column with unique values, that can be used to connect your original queries/tables. Like, if you have customer information in both tables, you will have a lot of duplicate data about these customers. Instead, create a separate customer data identified by customer number (in hope you have that, or something else that is unique - how else would you distinguish between customers?)
You can create these tables from your original queries by referencing them, keeping only the columns relevant to the new table, and remove duplicate rows (be sure to select all columns before adding that step).
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |