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

I cannot recreate this. Seems to work for me. I am on the December 2019 version of Power BI. See attached.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for trying. Not sure what the difference is. My guess would be that you are not using Direct Query and a Kusto connection. I checked my version and found this:

 

Version: 2.76.5678.782 64-bit (December 2019)

 

I will also mention that 2 other people I know tried and also reproduced the same error. So, it wasn't just me.

  • 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