Forum Discussion
Resolver IIIproposals count difference from month wise in visual
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
Microsoft EmployeeHi 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
Resolver III
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
- mehaboob557
Hi v-jiascu-msft,
Do you have any pbix file of the above report you have shown.
Please share me the pbix file.
- v-jiascu-msft
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