DAX to create a graph with Continuous Month on the X axis

[vmsouza30]

How can I create a DAX formula to appear every month of the year, even if one of them has no information, ie no sale occurred in that month.
In my case I can not cross a calendar table that would be ideal, nor any other data, since a bank connector comes with the data ready.
Do you have any formula that can solve my problem?

[tjd]

I believe that you're going to need a calendar table that continuously covers the date from your starting date to at least your end date.  Since you said you're using a "bank connector", I assume that you're using direct query and cannot connect your internal PowerBI date table to the query date.  The only alternative that I see is for you to contact the bank IT department and ask them to include a calendar/date table in their data.  Once you've got the relationship set up between your date table and the date column in the bank data, you use the date table month column on the x-axis and it should then plot each month even when no transactions occurred in that month.  Hope this helps.

[vmsouza30]

With the calendar table I do in other cases, but in that specific I can not now.

That is my problem, at that time TI does not have this availability and wanted to solve it in another way.

Does Via DAX have any formula?

[v-ljerr-msft]

Hi @vmsouza30,

With the calendar table I do in other cases, but in that specific I can not now.

That is my problem, at that time TI does not have this availability and wanted to solve it in another way.

Does Via DAX have any formula?

---

As creating new tables using DAX in DirectQuery is not supported currently, but an individual and continuous Calendar table is needed here, using DAX cannot do it in this scenario. 

Regards