cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mehaboob557 Member
Member

proposals 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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-jiascu-msft
Microsoft

Re: proposals 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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Microsoft v-jiascu-msft
Microsoft

Re: proposals count difference from month wise in visual

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mehaboob557 Member
Member

Re: proposals count difference from month wise in visual

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.

proposalscount.PNG

Microsoft v-jiascu-msft
Microsoft

Re: proposals count difference from month wise in visual

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 )

proposals count difference from month wise in visual.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mehaboob557 Member
Member

Re: proposals count difference from month wise in visual

Hi @v-jiascu-msft,

 

Do you have any pbix file of the above report you have shown.

 

Please share me the pbix file.

Microsoft v-jiascu-msft
Microsoft

Re: proposals 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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

mehaboob557 Member
Member

Re: proposals count difference from month wise in visual

Thank you @v-jiascu-msft 🙂

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)