Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

data month auery

hiii
i have a slicer named month name
now i want a line graph displaying past 2 months and current month data based on slicer month name selection.
how can i get it

https://drive.google.com/file/d/16YSO8dxe8KkxL4Av6vHlSSIfHdVhQZvH/view?usp=sharing

  • Icey's avatar
    Icey
    5 years ago

    Hello @greeshma ,

    Change the slicer field to "MonthName" in the "Dates" table.

    slicer.JPG

    Best regards

    Icey

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

5 Replies

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous ,

     

    I see you have some date column, which date column can you use as reference for the month name ? So we can create a measure to achieve what you want.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      i have used call closed date table

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Please check:

     

    1. Create another Dates table.

     

    Dates =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2020, 1, 1 ), DATE ( 2020, 12, 31 ) ),
    "Year", YEAR ( [Date] ),
    "Month", MONTH ( [Date] ),
    "MonthName", FORMAT ( [Date], "mmmm" )
)

     

     

    2. Create columns in your Query table.

     

    Call Closed Date = [Call Closed].[Date]

     

     

    YearMonth = FORMAT([Call Closed Date],"YYYY MMMM")

     

     

    3. Create relationship between the two tables.

     

    4. Create measures.

     

    M.SLA% 2 = CALCULATE([M.SLA%],DATESINPERIOD ( Dates[Date], MAX ( Dates[Date]), -3 , MONTH ))
    RAW SLA% 2 = CALCULATE([RAW SLA%],DATESINPERIOD ( Dates[Date], MAX ( Dates[Date]), -3 , MONTH ))
    Count of Call Closed = CALCULATE(COUNT(Query1[Call Closed]),DATESINPERIOD ( Dates[Date], MAX ( Dates[Date]), -3 , MONTH ))

     

     

    5. Create visuals.

     

     

     

    Best regards

    Icey

     

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      hi icey thank you for the help my issue now is the 3 month trend graph now if i go nd try to place it along with the other graphs displaing only the current month data. the 3 month graph goes it doesnt show any data in the graph.

      this graph doesnt shw any data

      greeshma_0-1603820920147.png

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support
        5 years ago

        Hello @greeshma ,

        Change the slicer field to "MonthName" in the "Dates" table.

        slicer.JPG

        Best regards

        Icey

        If this post helps, then consider Accepting it as the solution to help other members find it faster.