Display only date on the graphe

[mellas_k]

Hello ,

I have the below  graph and I need to show on Axe X only all months

But my problem that when I choose

I have the below graph:

So I have the sum of all months …, can someone help me to display the first graph with only all months and without calculate the sum.

Thanks for your help

[mellas_k]

Hi , 

Any help please ? 

[v-yulgu-msft]

Hi @mellas_k,

Change the X-axis type to Continuous as is shown in above screenshot will show all twelve months on axis. So what did you mean 'see all the months' and what is your current result after setting type to Continuous?

Best regards,
Yuliana Gu

[mellas_k]

Hi @v-yulgu-msft

When i change the  X-axis i have the below result 

And i need to show all 12 monthes .. 

thanks for your help.

[v-yulgu-msft]

Hi @mellas_k,

Please try to new a calendar table and create a one to many relationship to source table. Then, in chart visual, add date column from calendar table to X-axis. Repeat all above operations.

Regards,
Yuliana Gu

[mellas_k]

hi @v-yulgu-msft

If I understood correctly what you means ..  

i create a new table , i create a relation between it and  source table , but always i have the same issue ....

i can only see  4 or 5 months 

Best regards;

[v-yulgu-msft]

Hi @mellas_k,

You could try enlarge the width (drag the right margin manually) of the chart visual to make all months available on X-axis.

Regards,
Yuliana Gu

[mellas_k]

Hi @v-yulgu-msft

Same problem i can not display all the months ..

 thanks ;

[v-yulgu-msft]

Hi @mellas_k,

Could you try this workaround:

Create a calendar table:

Dim date = FILTER( CALENDAR(DATE(2016,1,1),DATE(2017,12,31)),DAY([Date])=1)

Union this calendar table and source table:

Union table =
UNION (
    ADDCOLUMNS ( 'Dim date', "Sales", 0 ),
    SELECTCOLUMNS (
        'SourceTable',
        "Date", 'SourceTable'[SalesDate],
        "Sales", 'SourceTable'[SalesValue]
    )
)

Drag date column and sales column from the union table into chart visual. Set X-axis type to categorical.

Regards,
Yuliana Gu

[dilumd]

Hi 

Try to use Format And Month functions to get the month name and then use it as the x axis’s. 

[mellas_k]

hi @dilumd

I tried to get the month name but I have the same issue ..

thanks 

[dilumd]

Hi

what if you change the graph formatting as below, (drill down up to date level but the date want shows up. I think this came up with a new update, if you don't see it please update power BI desktop to latest version.

[mellas_k]

HI @dilumd 

thanks for your answer , yes i did it but my boss wants to see all the months .. 

i have not the choice ..