Data format

[DigitalAutomat]

Hello,

I have a problem in creating groups from a column: I need to have several new groups ("2 giorni", "da 2 a 5 giorni", "oltre 5 giorni") in numeric format but at the end I have these in text format (with the addition of the "Altro" field) and so I have a big problem in the creation of graphs.

Please find the photo attached.

Thank you very much for help me,

Nicola

[Greg_Deckler]

@DigitalAutomat Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[DigitalAutomat]

Dear @Greg_Deckler ,

Thank you for your kind answer and clarifications; here is my sample text:

date		delivery time (days)
29th january		2
28th january		1
27th january		5
26th january		4
25th january		3
20th january		2
14th january		1

First of all I need to create 3 groups, based on the following delivery time:

first group: delivery within 2 days

second group: delivery between 2 and 5 days

third group: delivery over 5 days

this is a sample table based on my previous data:

delivery in 1 day:		delivery between 2 and 5 days:		delivery over 5 days:
2		5		0

Lastly, I need to create a pie chart related to these data, like this one:

Please feel free to ask if you need any additional information.

Thanking for your help I look forward to hearing from you.

Kind regards,

Nicola

[Greg_Deckler · Accepted solution]

@DigitalAutomat Seems like:

Column = 
  SWITCH(TRUE(),
    [delivery time (days)] < 2, "delivery within 2 days",
    [delivery time (days)] >= 2 && [delivery time (days)] <= 5, "delivery between 2 and 5 days",
    "delivery over 5 days"
  )