Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |