Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mehaboob557
Resolver III
Resolver III

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

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
v-jiascu-msft
Microsoft Employee
Microsoft 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

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.

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

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.

Hi @v-jiascu-msft,

 

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

 

Please share me the pbix file.

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.

Thank you @v-jiascu-msft 🙂

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors