Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more

Reply
dlflima
Regular Visitor

Forecasting

‎09-26-2017 11:42 AM

Hello,

I have a payment table that have the following information:

  • PAYMENT RECEIVER;
  • VALUE;
  • PAYMENT CYCLE;
  • PAYMENT TYPE;
  • PAYMENT SEGMENT.

I'd like to make a forecast for the following payment cycles, where I can filter the receiver and / or the payment type, while the graphic shown is created by the payment ciclo, value and segment, like the image below.Capture.PNG

 

 

I'd like to make a forecast for the next 12 cycles.

Can you guys help me, please?

Thanks you

Message 1 of 4
1,330 Views
0
3 REPLIES 3
Anonymous
Not applicable

‎09-27-2017 07:27 PM

HI @dlflima,

 

Current forecast feature only available on line chart and it also not works when you enable legend fields on line chart.

For your requirement, you can submit an idea or manual analysis the forecast value to generate records and  merge them with original records to a new table. Finally, use new table as the source of chart.

 

Regards,

Xiaoxin Sheng

Message 4 of 4
1,302 Views
0
Anonymous
Not applicable

‎09-26-2017 08:26 PM

Hi @dlflima

 

 

Can you share some sample data in excel format in one drive and post the link here to find a solution.

 

 

Cheers

 

CheenuSing

Message 2 of 4
1,309 Views
0
dlflima
Regular Visitor
In response to Anonymous

‎10-17-2017 06:28 AM

Hi @Anonymous,

Sorry I took so long to reply.

Here's my spreadsheet sample:

 

PAYMENT RECEIVERVALUEPAYMENT TYPEPAYMENT CYCLEPAYMENT SEGMENT
1001078720,00COMISSÃO VELOX350FIXA
1001078728,00COMISSÃO CANAIS LOCAIS350FIXA
1001078113,00COMISSÃO BONUS IQV – FIXA350FIXA
10010784.456,00BONIFICAÇÃO CONTROLE350MOVEL
10010781.569,00BONIFICAÇÃO LOW-HIGH350MOVEL
1001078273,00REEMBOLSO350MOVEL
1001078134,66PRICE PROTECTION350MOVEL
1001078823,00BONIFICAÇÃO VELOX 3G350MOVEL
10010782.266,40COMISSÃO DADOS VELOX 3G350MOVEL
1001078145,00REEMBOLSO DE CAMPANHA SIMCARD 350MOVEL
1001078413,40COMISSÃO BONUS IQV350MOVEL
10015002.560,00COMISSÃO VELOX350FIXA
10015001.049,00COMISSÃO CANAIS LOCAIS350FIXA
1001500325,60COMISSÃO BONUS IQV – FIXA350FIXA
10015006.260,00BONIFICAÇÃO CONTROLE350MOVEL
100150020,00BONIFICAÇÃO LOW-HIGH350MOVEL
100150066,49PRICE PROTECTION350MOVEL
10015001.349,00COMISSÃO OI TV DTH350MOVEL
10015001.703,00COMISSÃO DADOS VELOX 3G350MOVEL
1001500137,00REEMBOLSO DE CAMPANHA SIMCARD 350MOVEL
1001500595,05COMISSÃO BONUS IQV350MOVEL
1001078640,00COMISSÃO VELOX351FIXA
1001078625,00COMISSÃO CANAIS LOCAIS351FIXA
10010785.296,00BONIFICAÇÃO LOW-HIGH351MOVEL
1001078480,00COMISSÃO OI D+351MOVEL
10010781.333,00BONIFICAÇÃO CONTROLE351MOVEL
100107830,00REEMBOLSO351MOVEL
1001078740,17PRICE PROTECTION351MOVEL
1001078422,00BONIFICAÇÃO VELOX 3G351MOVEL
10010784.005,00COMISSÃO DADOS VELOX 3G351MOVEL
1001078811,00COMISSÃO UPGRADE MÓVEL351MOVEL
1001078262,00REEMBOLSO DE CAMPANHA SIMCARD 351MOVEL
10015003.820,00COMISSÃO VELOX351FIXA
10015002.190,00COMISSÃO CANAIS LOCAIS351FIXA
10015003.460,00BONIFICAÇÃO CONTROLE351MOVEL
10015002.382,00BONIFICAÇÃO LOW-HIGH351MOVEL
10015001.200,00COMISSÃO OI D+351MOVEL
100150091,69PRICE PROTECTION351MOVEL
10015001.054,00BONIFICAÇÃO VELOX 3G351MOVEL
1001500342,00COMISSÃO OI TV DTH351MOVEL
10015002.244,00COMISSÃO DADOS VELOX 3G351MOVEL
1001500167,00COMISSÃO UPGRADE MÓVEL351MOVEL
100150080,00BONIFICAÇÃO RECARGA 351MOVEL
1001500150,00REEMBOLSO DE CAMPANHA SIMCARD 351MOVEL
1001078406,00COMISSÃO VELOX352FIXA
1001078607,00COMISSÃO CANAIS LOCAIS352FIXA
10010782.800,00BONIFICAÇÃO CONTROLE352MOVEL
10010784.659,60BONIFICAÇÃO LOW-HIGH352MOVEL
1001078762,00REEMBOLSO352MOVEL
1001078691,05PRICE PROTECTION352MOVEL
1001078260,00BONIFICAÇÃO VELOX 3G352MOVEL
10010782.962,20COMISSÃO DADOS VELOX 3G352MOVEL
1001078130,00REEMBOLSO DE CAMPANHA SIMCARD 352MOVEL
1001078348,15COMISSÃO BONUS IQV352MOVEL
10015003.420,00COMISSÃO VELOX352FIXA
10015001.271,00COMISSÃO CANAIS LOCAIS352FIXA
10015004.190,00BONIFICAÇÃO CONTROLE352MOVEL
10015001.590,50BONIFICAÇÃO LOW-HIGH352MOVEL
100150088,84PRICE PROTECTION352MOVEL
1001500122,00BONIFICAÇÃO VELOX 3G352MOVEL
10015001.125,00COMISSÃO OI TV DTH352MOVEL
10015002.964,00COMISSÃO DADOS VELOX 3G352MOVEL
1001500108,00REEMBOLSO DE CAMPANHA SIMCARD 352MOVEL
1001500403,20COMISSÃO BONUS IQV352MOVEL
Message 3 of 4
1,294 Views
0

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All