Forum Discussion

mellas_k's avatar
mellas_k
Icon for Helper I rankHelper I
9 years ago

Display only date on the graphe

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 …, ca...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
mellas_k
Icon for Helper I rankHelper I
9 years ago

Hi v-yulgu-msft

 

Same problem i can not display all the months ..

 thanks ;

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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