Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to bin small decimal values

Hello,   I recently tried to create a histogram in Power BI from some data that ranged between 0 and 0.140. I right clicked the data and created a a new group. I selected Group Type to be "bin" and...
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    It turns out to be a problem in the Kusto connector. Fixes are planned. One work around is to bin it in the query. This works today.

     

    let
        Source = Kusto.Contents("<cluster>", "<database>", "<table> | extend slack_bin=bin(slack, 0.01)", [MaxRows=null, MaxSize=null, NoTruncate=null, AdditionalSetStatements=null])
    in
        Source
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Yep, I'm just using Import with an Enter Data query so my suspicion would be that this is some kind of problem with DirectQuery.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It turns out to be a problem in the Kusto connector. Fixes are planned. One work around is to bin it in the query. This works today.

 

let
    Source = Kusto.Contents("<cluster>", "<database>", "<table> | extend slack_bin=bin(slack, 0.01)", [MaxRows=null, MaxSize=null, NoTruncate=null, AdditionalSetStatements=null])
in
    Source