hiiii 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
Go to Solution.
Hello @greeshma ,
Change the slicer field to "MonthName" in the "Dates" table.
If this post helps, then consider Accepting it as the solution to help other members find it faster.
View solution in original post
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.
Proud to be a Super User!
i have used call closed date table
Hi @greeshma ,
1. Create another Dates table.
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.
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
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.