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.
Hey,
I'm importing data from google bigquery, i have 4 tables, all include a dateCompleted column but some of the data need to be sliced using userCreatedOn. how can i use one slicer for these different columns?
Solved! Go to Solution.
I think you can use 'userelationship' formula. You can link your calendar table to both datecompleted column and usercreatedon column. One line will be dot line. When you want to create meausre by that date column. You add userelationship formula in the measure to activate that relationship.
Thanks
Proud to be a Super User!
I think you can use 'userelationship' formula. You can link your calendar table to both datecompleted column and usercreatedon column. One line will be dot line. When you want to create meausre by that date column. You add userelationship formula in the measure to activate that relationship.
Thanks
Proud to be a Super User!
@ryan_mayu Agreed. I would only add a note that whichever relationship is active is the default unless otherwise specified.
Also here is the doc for USERELATIONSHIP. https://docs.microsoft.com/en-us/dax/userelationship-function-dax
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 |
---|---|
107 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |