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 a dataset that I prepared using PowerBI desktop. It contains a date column called tDate. When I upload this PowerBI and start using the Q&A, it does not slice/filter the data correctly. For example, if I ask "Show Total PaidAmt" it will show 30M, representing the total paid over the entire data set. If I type in "Show Total PaidAmt in last two weeks" I see the DATE filter pop up correctly in the report, but it doesnt show the correct information. It still shows 30M.
I tried a new dataset and the same thing happened. Everything was working fine, then I upgraded the powerBI desktop to the lastest version and have not had success since.
Interestingly, when i try to see the dates "Show tDates" it only shows one date. 1/1/2015. (I have data from 2012 to today). If say "Show tDates in last week" the Q&A helper pops up the following suggestion.
"Show date table template a 04189 0f 1030 4975 ace 9 6158 9afb 8f 54 and their date where date is last week"
Mannualy dragging the tDate column to the filter and applying it DOES work correctly.
Any ideas? Thanks!
Solved! Go to Solution.
I fixed the issue by going into PowerBI->Options and Settings->Options-> Current File-> Data Load-> Uncheck Auto Date/Time
Saved, published, *Cleared IE's Browser History* and it worked.
*Note, I did try clearing the brower history prior to this, so it wasn't the only issue. Maybe you don't need to do it, who knows. Just letting you know the exact steps I took to fix it.
I fixed the issue by going into PowerBI->Options and Settings->Options-> Current File-> Data Load-> Uncheck Auto Date/Time
Saved, published, *Cleared IE's Browser History* and it worked.
*Note, I did try clearing the brower history prior to this, so it wasn't the only issue. Maybe you don't need to do it, who knows. Just letting you know the exact steps I took to fix it.
The December PowerBI Desktop update did NOT fix this. Auto Date/time is still not working.
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.