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,

 

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

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'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