cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CmdrKeene Regular Visitor
Regular Visitor

Using date field with Q&A

My dataset has a date field (date only, no time value in it) called "CallDate". I can see it in my Dataset, I can create a report using it like so: PowerBI Report Screenshot

 

On the Axis field, I set the CallDate to just "CallDate", because setting "Date Hierarchy" makes the user need to "drill down" and I don't want that, I want it to just be per-date as shown in that picture.

 

I can save that report fine, and I can even pin it to a dashboard.  But then Q&A doesn't work.  If you type a phrase like "average of AgentTime by CallDate", the "by CallDate" turns gray like it doesn't understand the request.

 

The CallDate is a date field in my data source, and I've tried shaping the query many different ways and even creating new date columns in PowerBI desktop, then publishing. But nothing I can do will make this report work correctly.

 

Example of the problem: PowerBI Dashboard Screenshot


CmdrKeene
2 REPLIES 2
Grijn Frequent Visitor
Frequent Visitor

Re: Using date field with Q&A

I'm running into the same issue. Did you get it working?

CmdrKeene Regular Visitor
Regular Visitor

Re: Using date field with Q&A

Not yet but I do have an open support case on it.  It's just a bit slow because I'm a free user.


CmdrKeene

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 296 members 3,103 guests
Please welcome our newest community members: