Forum Discussion

wollmilchsau's avatar
wollmilchsau
New Member
10 years ago

Summing-up monthly data

Hi  community,

 

any help appreciated.

 

My data look like this

 

Dec 14      1        Quote by Mr. X
Dec 14      1        Quote by Mr. Y

Dec 14      1        Quote by Mr. z
Jan 15      1        Quote by Mr. X

Jan 15      1        Quote by Mr. Y

Jan 15      1        Quote by Mr. Z

Dec 15      1        Quote by Mr. X

Dec 15      1        Quote by Mr. Y

Dec 15      1        Quote by Mr. Z

 

I would like to dispaly the data in a bar chart shwing the number of Quotes in Dec 14 (3), then Jan 15 (3), then Dec 15 (3).

No way!

 

I only get any kind of charts showing:

 

Dec (6), Jan (3). 

 

No developmnet is shown. Just the monthly aggregation regardless the year. I can campare which month is statisticly the best. But can't obsereve the month by month development from year to year. 

 

Only when my input data looks like this i was able to get the result i wish:

 

Dec 14  - 3 Quites

Jan 15 - 3 Quotes

Dec 15 - 3 Quotes

 

Unfortunately that's not the way my CRM outputs the data. It#s always like in the first example.

 

Any ideas?

 

Thank you!

 

Alex

 

1 Reply

  • PowerBIGuy's avatar
    PowerBIGuy
    Responsive Resident

    Are you using the Power BI web service or Power BI desktop. I think your data is being translated into for example "Dec 14 into 12/14/2015". If you are or can use Power BI desktop you will need to convert your dates into strings or replace for example 12/14/2015 with 12/01/2014.