cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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.

View solution in original post

5 REPLIES 5
Super User III
Super User III

@greeshma ,

 

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.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



i have used call closed date table

Community Support
Community Support

Hi @greeshma ,

 

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]

 

date.JPG

 

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

 

 

3. Create relationship between the two tables.

relationship.jpg

 

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.

visuals2.JPGvisuals1.JPG

 

 

 

Best regards

Icey

 

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

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

Community Support
Community Support

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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors