Any suggestion to create this table in Power BI

[TANA]

Hi, 

Can someone give me suggestion how to replicate the table from Excel to Power BI? Thanks, 

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file.  Claearly show how the Total year forecast has to be calculated.  Should the YTD actual calulcation be based on today's date or month selected in a slicer?

[TANA]

Hi, thanks for your help. 

For now, there is no calculation. It just a manul input. Thanks, 

[Ashish_Mathur]

Hi,

With just that much information, atleast i will be unable to help you.

[TANA]

Thanks for your help. 

[amitchandak]

@TANA , In Matrix visual, switch values on row. All of them should be measures.

Switch values to row - https://youtu.be/cN8AO3_vmlY?t=11650

[TANA]

Hi, @amitchandak 

Do you have time to help me further? I provided more info on my earlier post. Can you please help me? thanks, 

[TANA]

@amitchandak 

Thank you for your suggestions! I got switch value to row so far, but not measure. Can you please help me? Thanks, 

I have switched my data in excel like this in order to get to graph above. Is that necessary? Please advise. 

Actually, the box is just one of sample, my ultimate goal is to have 8 of them. Do you have any suggestion? Do I have to switch the data in Excel like above for each project and each box? I have more than 100 projects. Please help me. Appreciated!