Power BI bin, group by day using direct query

[philorican]

I am having issues displaying a graph in Power BI after I publish it in the cloud.  I realized that when I created a bin, grouped by day for resolved date and select it as part of the graph, I experience the issue.  But when I select the original date, the graph displays each day with time but not grouped day.  Any reason why it does not display the graph when using the bins?

 

[v-caliao-msft]

Hi @philorican,

I have tested it on my local environment, we can not reproduce this issue. Here is my sample data.

Then create a bin measure by using the DAX below.
Bins = CALCULATE(COUNTROWS(FILTER('Table',and('Table'[SaleAmount] >= min(Buckets[Min]),'Table'[SaleAmount]<= MAX(Buckets[Max])))))

And this measure works well after published report to Power BI services.

In your scenario, please provide us your report details and some sample data, so that we can make further analysis.

Regards,

Charlie Liao

[philorican]

Charlie,

I forgot to mention that I am using Power BI gateway via DirectQuery. 

Here are examples of the report I created and details.  Please note that the count are the summary count of each closed ticket for the days they were closed.  I just removed the ticket numbers so I can get a daily summary count on the report.  You'll need to create some tickets to recreate my issue.

Resolved date fields: Original field vs Group Bin Field

Resolved Date Day Group Bin

Resolved date original format

This is the result I get when I publish the report to Power BI. The Group Bin just spins with no data while the original date format shows the result.