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 all!
I have two tables, one with information about workers and the other with info about bills. I need that when I select a date from slicer (Wich have dates from Bills Table) the barchart gets update but it doesn't. I must have the date from Bills Table on slicer. How can i do this? I attach a PBIX file with example of my problem (I want the bar chart next to the slicer as the one below it.)
Regards
Solved! Go to Solution.
I just solved it!
I've had to create a new table that only has the Dates that are in my original Database, then I relate these new Date Field to the others Date Fields in my existing tables and it works! Just have to remember that in the new table, it must be a unique date field for each one that exists in the original tables that are in the data base.
Regards
I have two tables with Column name "Reference number" . i am traying to create a relationship but it’s not working
any idea why
Data Type is "Text" for both
Because your join is resulting only Feb data.
You need to look through your data and make a join again.
I just solved it!
I've had to create a new table that only has the Dates that are in my original Database, then I relate these new Date Field to the others Date Fields in my existing tables and it works! Just have to remember that in the new table, it must be a unique date field for each one that exists in the original tables that are in the data base.
Regards
You have only February result because:
The Only UniqueIdentifier that match with UserID (Workers Table) are 4,9 and 13.
Regards
Victor
Lima - Peru
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 |
---|---|
113 | |
98 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |