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 two sheets in excel both have column called "Month" and both have the same exact format. When I drag one of them, power bi shows the dates for all the months and years while the other shows me only first date of each month.
Please help.
Thanks!
Solved! Go to Solution.
I think you have to change the format of your column in data mode, where you have all your database: select your column and change the format in "modeling menu"
Hi @Omega,
Can you share your pbix file?
1. Where did you see the difference? If they are in different context, they will return different values.
2. What's the relationship?
3. Do they have the same values?
Best Regards,
Dale
I think you have to change the format of your column in data mode, where you have all your database: select your column and change the format in "modeling menu"
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 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |