Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Olá amigos,
Estou com dificuldades em criar um gráfico de chrun de clientes. A ideia era ficar algo desse tipo:
Unica diferença que gostária de unidade no eixo Y.
Os dados que tenho em tabela são. Email, telefone, Status (Ativo ou Cancelado), Data de Inicio e Data de Fim (se estiver ativo é sempre o dia atual).
Outro detalhe, gostária que fosse no tipo por "safra", Uma das linhas é os clientes que entraram no Mês 1, a outra Mês 2 e assim por diante.
Estou perdido. Por favor, me deem uma luz.
Grato desde já!
Solved! Go to Solution.
Hi @Marlon
It seems you may create a table like below and then create different measures to get the different lines.
Table = FILTER ( GENERATE ( 'Date', Table1 ), Table1[Join Date] <= 'Date'[Date] && Table1[Left Date] >= 'Date'[Date] && Table1[Status] = "Active" )
Regards,
Hi @Marlon
It seems you may create measures to get different line values.For example:
MeasureForMonth 1 = CALCULATE ( COUNT ( Table[Customer] ), FILTER ( Table, Table[Month] = 1 ) )
If it is not your case,sample data and expected output will be helpful to provide an accurate solution.Please refer to How to Get Your Question Answered Quickly to post your question.
Regards,
Hello @v-cherch-msft , thanks for awnsering.
The data is like this
Nome | Phone | Join Date | Status | Left Date | |
Person1 | person1@email.com | 11111111111 | 03/01/2019 | Active | 27/03/2019 |
Person2 | person2@email.com | 2222222222 | 08/01/2019 | Canceled | 07/03/2019 |
Person3 | person3@email.com | 3333333333 | 13/01/2019 | Active | 27/03/2019 |
Person4 | person4@email.com | 4444444444 | 07/02/2019 | Active | 27/03/2019 |
Person5 | person5@email.com | 5555555555 | 09/02/2019 | Canceled | 09/03/2019 |
Person6 | person6@email.com | 6666666666 | 13/03/2019 | Active | 27/03/2019 |
Person7 | person7@email.com | 7777777777 | 06/03/2019 | Active | 27/03/2019 |
And i want to show a graphical like in the first post.
Being the Y = Count of how many person are active and X = Month. But i want to separe the datas like one line for who joined in january, a line for who joined Febuary...
Thanks for your patience and sorry for my english.
Hi @Marlon
It seems you may create a table like below and then create different measures to get the different lines.
Table = FILTER ( GENERATE ( 'Date', Table1 ), Table1[Join Date] <= 'Date'[Date] && Table1[Left Date] >= 'Date'[Date] && Table1[Status] = "Active" )
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
101 | |
75 | |
63 | |
62 |
User | Count |
---|---|
141 | |
104 | |
101 | |
80 | |
67 |