Forum Discussion
Resolver IIIproposals count difference from month wise in visual
Hello All,
I have proposal's and date. Count of proposals nothing but sales.
I want to show a visual 1) x axis as date and y axis as column
2) sales comparision from previous month. sales on same month but last year and this year comparission
how can i show the above visuals perfectly.
Please suggest me
Hi mehaboob557,
Please check it out here: https://1drv.ms/u/s!ArTqPk2pu-BkgRQ_Pzt5AJFzuWGi.
It may be a little different in the appearance. I left the old one at home. And I add a yearly comparison.
Best Regards!
Dale
6 Replies
v-jiascu-msftMicrosoft Employee
Hi mehaboob557,
What kind of data do you have? Could you please provide a sample in text mode (or the pbix file)? Maybe two visuals are needed.
Best Regards!
Dale
- mehaboob557
I wanna show the difference of proposalId count(nothinh but sales) in last month and current month . (OR) i will select the months and i wanna know the sales on those months and how the sales increased or descreased in visual.
Below is the sampple current visual i had. You can see the table where proposalId and date colums u can see.
- v-jiascu-msft
Hi mehaboob557,
Due to lack of accurate data, you can try a formula like this. The visual could be "line and stacked column chart".
MonthlyCount = COUNT ( Sales[Quantity] )
Comparision = VAR pID_last_month = CALCULATE ( COUNT ( Sales[Quantity] ), PREVIOUSMONTH ( 'Date'[Date] ) ) RETURN DIVIDE ( pID_last_month, COUNT ( Sales[Quantity] ), 0 )Best Regards!
Dale