Binning Data in service or semantic models

[ReneT]

Hi, in BI desktop one can greate a group to bin data. This is used for plotting histograms etc. I can't find anyway of doing this in Fabric, BI Service, or BI desktop when connected to a semantic model. There has got to be a way of doing this easily. I don't think it can be done with DAX as it needs to make a dynamic array of values.  

Kudos to anyone that has figured this out! 

[Anonymous]

Hi @ReneT , hello SaiTejaTalasila  and mattiasdesmet, thank you for your prompt reply!

Currently, this feature is not supported by the Power BI service.

I would suggest you submit your ideal at this page, If this feature was mentioned by many users, product team will consider to add this feature to next release. 

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SaiTejaTalasila]

Hi @ReneT ,

If the purpose is to do EDA on your semantic model data you can use semantic link and pull the data to a dataframe and you do your analysis on fabric notebooks.

Please refer this -

https://learn.microsoft.com/en-us/fabric/data-science/semantic-link-overview

I hope it will be helpful.

Thanks,

Sai Teja 

[ReneT]

Thanks Sai,  This is a good solution for EDA but I would like to display a dynamic histogram on a deployed report. I guess this functionality is not available yet. I will have to request it.

[mattiasdesmet]

Creating groups is a change to the semantic model. It adds a calculated column to the model with this syntax

SWITCH(
TRUE,
ISBLANK('Person'[Age]),
"(Blank)",
'Person'[Age] IN {0,1,2,3},
"Baby",
'Person'[Age] IN {4,5,6,7,8},
"Infant",
'Person'[Age] IN {9,10,11,12,13,14,15,16,17},
"Teenager",
'Person'[Age] IN {-1},
"Unknown",
"Adult"
)

You can only add measures to reports with a live connection, not modify the semantic model.

There is a preview setting that allows you to modify the datamodel : Edit data models in the Power BI service (preview) - Power BI | Microsoft Learn

Perhaps this can help? You can then create a column with about code.

[ReneT]

Thank you.  I'm happy to do it by changing the semantic model but there is no option for groups as before (in BI desktop)  The dax code you give hard codes bins but with groups you can have dynamic binning with number of bins, this then repones to any filtering in the report.  This is what I want to achieve.