Forum Discussion
Post ProdigySingle BAR Graph for Comparing Previous Year each months V/s Current Year Each Months
Post ProdigyHi Musadev
I have just uploaded sample pbix file, pls find the below link to access
https://drive.google.com/file/d/1lDc2W7vN0chh7n3xevJHDcqQJ2FwLJyM/view?usp=sharing
Regards,
Hari
Resolver IIIharirao
I have performed multiple transformations to your sheet.
1- Split the text date into Month (Mmm) and Year (yyyy) and then concatenate them into a new column Month Year.
2- The above steps for both tables
3- Change the relationships to the new columns Month Year
4- Add 2 measures, one for this year total value and one for last year. (check Key Measures table)
5- check the tables and the chart for more details.
Here is PBIX file.
https://drive.google.com/file/d/1EPkxiucQzPiWlfsTiljK_9upLQRhbYUY/view?usp=sharing
- harirao
Hi Musadev
Thank you so much for providing Solution which is giving correct result.
However after creating Clustered Column Chart noticed that Previous Year Month & Current Year Months are not next to each other.
If i try to arrange Nov-22 is coming as single Bar and in middle Nov-23 is coming with two bar's that is Total Value LY & Total Value TY Stating/Showing Nov-23 only as i want to See Nov-22& Nov-23Thank you
Regards,
Hari- Musadev
- harirao
Hi Musadev
Thank you for your assistance. After excluding blanks, it's working well.
I have another query regarding formatting. Is it possible to display both month names as "Nov-22" and "Nov-23" when tooltips are enabled? Additionally, could each month's names be shown next to each other like "Nov-22 || Nov-23"? This formatting would be helpful for presentations.
Thank you once again for your help and assistance.
Regards,
Hari
- Musadev
Chech the visual filter and remove the null values for last year. I will update the pbix file and will it tomorrow