Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vmsouza30
Helper I
Helper I

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

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?

3 REPLIES 3
tjd
Impactful Individual
Impactful Individual

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.

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?

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. Smiley Happy

 

Regards

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors