proposals count difference from month wise in visual

[mehaboob557]

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

[v-jiascu-msft]

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]

Hi @v-jiascu-msft

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 · Accepted solution]

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

[mehaboob557]

Thank you @v-jiascu-msft 🙂