Need help to build a report

Hi danielsouza

You need to un-pivot your columns and link them to a date table.

1. First see this video and create a date table. https://youtu.be/vJ7xNUK8sQE

2. Next go to your query editor for your query, highlight the first column [Description] by clicking on the header, right click the header and click 'Unpivot Other Columns'. This will put your data in a better format. You then need to perhaps add a year and day to your Month and create a 'Date'.

3. Link the date to the date table in your relationships

4. You should then be able to create the graph as you showed.

Let me know how you get on.

Thanks

shebr

In DAX, you can do this:

Month Name =
FORMAT ( DATE ( 2017, 'Table'[Month Number], 1 ), "mmmm" )

You can replace 2017 with any year you want. The goal here to is to create a valid date and extract the month name from that date.

By the way, what are you going to do with 13?