Forum Discussion

philorican's avatar
philorican
Frequent Visitor
9 years ago

Power BI bin, group by day using direct query

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 experi...
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
philorican
Frequent Visitor
9 years ago

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.