Forum Discussion
Month transformation
Hi,
I have some issues about representing data.
I got this table :
| Date | Option | Number of sales |
| 01/01/2019 | A | 1 |
| 01/01/2019 | B | 2 |
| 01/02/2019 | A | 3 |
| 01/02/2019 | B | 4 |
| 01/03/2019 | A | 5 |
| 01/03/2019 | B | 6 |
| 01/04/2019 | A | 7 |
| 01/04/2019 | B | 8 |
i would like to draw the number of sales by month using a slicer.
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).
Do you know if it is possible to get this result ?
Thanks in advance !
Thomas94401 it is not that straightforward, see an attached solution, tweak as you see fit.
✨ Follow us on LinkedIn
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 ❤ 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!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
2 Replies
Thomas94401 it is not that straightforward, see an attached solution, tweak as you see fit.
✨ Follow us on LinkedIn
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 ❤ 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!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
