Forum Discussion

vchan's avatar
vchan
Regular Visitor
7 years ago

How to visualize data from a long term plan consisting of multiple spreadsheets

Hi,   I am new to both Power BI and this forum, so I apologize in advance if I am asking something obvious.   Suppose I have 4 spreadsheet tabs all looking like this:   Asset     2019       202...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

vchan，

Do you need to add Year to X-Axis in your bar chart? Could you please share me your current PBIX file?

Regards,
Lydia

vchan's avatar
vchan
Regular Visitor
7 years ago

Hi Lydia,

 

Adding "Year" to the x-axis would be informative, but I could live with only being able to see one year at a time (or the average of a few years) like the graphs I have included on Oct 11. Having said that, the bigger challenge for me is how I could avoid the process of normalizing the data supplied to me in the format as per attached every time the forecasts are updated. (Please see attached Excel documents.) I apologize I do not have authority to share the pbix file which contain commercially confidential projections. Thanks much in advance.

 

Regards,

H:\Other Content\Data\Work\Archives\2018\Analytics\20180910 Pjt 26 Digitization potentials for CPC\Sample data 20181016.xlsx

 

H:\Other Content\Data\Work\Archives\2018\Analytics\20180910 Pjt 26 Digitization potentials for CPC\Sample normalized data 20181016.xlsx

Victor

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    vchan,

    I am unable to access the above link. You can share dummy data of your table here and post expected result based on sample data. And you can upload Excel file to OneDrive and then post shared link of Excel file here.

    Regards,
    Lydia