Forum Discussion
Grouping a column with numbers and null values
Hi Anonymous ,
Do you have defined groups that you require? Like how many total groups you need?
What is the minimum and maximum value in this column "Days between last promised shipment date and actual shipment date" ?
You can try to create BINS in Power BI. Consider the scenario where I have got Totals Sales displayed over-time.
Now I want to create BINS for the SALES value displayed above.
What I will do is, under FIELDS PANE, right-click on my SALES column and get following options and select NEW GROUP:
A new window opens where I can create some bins using options based on my requirement:
Read more about Bons here: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning#using-binning
Once you create bins, a new grouping appears as follows under Fields pane below your column:
Then you can use those BINS under LEGEND area to show the groups by different colors for sales value (in my case):
In a tree-map visual you can achieve something as below:
My bins are marked in RED in above visual.
Let me know if this is what you are looking for.
Thanks,
Pragati
Hi Pragati11
The data table is quite straighforward.
There are 3 columns
1. Last promised shipment date
2. Actual shipment date
3. Days between last promised shipment date and actual shipment date.
And i just need to group the last column.
If i dont do anything with the data i can show the distribution and see that 670.000 orders were delivered same day as promised, but i would like to group those numbers, so i say everything between +1 to 5 days. and -1 to -5 days etc.
Super UserHi Anonymous ,
Do you have defined groups that you require? Like how many total groups you need?
What is the minimum and maximum value in this column "Days between last promised shipment date and actual shipment date" ?
You can try to create BINS in Power BI. Consider the scenario where I have got Totals Sales displayed over-time.
Now I want to create BINS for the SALES value displayed above.
What I will do is, under FIELDS PANE, right-click on my SALES column and get following options and select NEW GROUP:
A new window opens where I can create some bins using options based on my requirement:
Read more about Bons here: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning#using-binning
Once you create bins, a new grouping appears as follows under Fields pane below your column:
Then you can use those BINS under LEGEND area to show the groups by different colors for sales value (in my case):
In a tree-map visual you can achieve something as below:
My bins are marked in RED in above visual.
Let me know if this is what you are looking for.
Thanks,
Pragati