Month transformation

Question

Hi,&nbsp;&nbsp;I have some issues about representing data.&nbsp;I got this table :&nbsp;&nbsp;DateOption&nbsp;Number of sales01/01/2019A101/01/2019B201/02/2019A301/02/2019B401/03/2019A501/03/2019B601/04/2019A701/04/2019B8&nbsp;i would like to draw the number of sales by month using a slicer.&nbsp;&nbsp;Instead of having 2 and 3 in x-axis, corresponding to the month number, I prefer having M1 and M2 (for the first month and second month of the slicer).&nbsp;Do you know if it is possible to get this result ?&nbsp;Thanks in advance !&nbsp;

parry2k · Accepted Answer

Thomas94401&nbsp;it is not that straightforward, see an attached solution, tweak as you see fit.
&nbsp;
✨ Follow us on LinkedIn 
&nbsp;
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation! 
&nbsp;
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Forum Discussion

Related content

Table Transformation

Transform a date to year-month

Table Transformation

M Language Transformations

Data transform using power query