Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

slicer

hiii i am tring to filter my data based on slicer i have a slicer with months if i click on a moth the data in line graph changes and didplay past 2 mnths and present month data which i wanted. no...
Need Help
Show and Tell
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Sorry for the late reply!

    Modify your measures for M.SLA%1 and RAW_SLA%1 as below:

    M.SLA% 1 = 
IF(MONTH(MAX('Query1'[Call Closed])) <= SELECTEDVALUE('Table'[Month])
            && MONTH(MAX('Query1'[Call Closed])) >=SELECTEDVALUE('Table'[Month])-2,
CALCULATE (
    [M.SLA%],
    FILTER (
        ALL(Query1),
        MONTH('Query1'[Call Closed]) <= SELECTEDVALUE('Table'[Month])
            && MONTH('Query1'[Call Closed]) >=SELECTEDVALUE('Table'[Month])-2
            && Query1[Call Closed].[Year] = YEAR ( TODAY () )
    )
),BLANK()
)
    RAW_SLA% 1 = 
IF(MONTH(MAX('Query1'[Call Closed])) <= SELECTEDVALUE('Table'[Month])
            && MONTH(MAX('Query1'[Call Closed])) >=SELECTEDVALUE('Table'[Month])-2,
CALCULATE (
    [RAW SLA%],
    FILTER (
        ALL(Query1),
        MONTH('Query1'[Call Closed]) <= SELECTEDVALUE('Table'[Month])
            && MONTH('Query1'[Call Closed]) >=SELECTEDVALUE('Table'[Month])-2
            && Query1[Call Closed].[Year] = YEAR ( TODAY () )
    )
),BLANK())

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
     
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  Anonymous ,

 

Modify your measure as below:

M HIT = CALCULATE (COUNT ( Query1[Priority] ),FILTER (Query1,Query1[SLA Status] = "FULFILLED"&& Query1[Exempted SLA] = "N"&&MONTH('Query1'[Call Closed])=SELECTEDVALUE('Table'[Month])))

+ CALCULATE(COUNT( Query1[Priority] ),FILTER(Query1,Query1 [SLA Status] = "EXPIRED" 

&& Query1 [Exempted SLA] = "Y"&&MONTH('Query1'[Call Closed])=SELECTEDVALUE('Table'[Month])))


M. MISS = 
CALCULATE (
    COUNT ( Query1[Priority] ),
    FILTER (
        Query1,
        Query1[SLA Status] = "EXPIRED"
            && Query1[Exempted SLA] = "N"&&MONTH('Query1'[Call Closed])=SELECTEDVALUE('Table'[Month])
    )
)


RAW HIT = CALCULATE (
    COUNT ( Query1[Priority] ),
    FILTER (
        Query1,
        Query1[SLA Status] = "FULFILLED"&&MONTH('Query1'[Call Closed])=SELECTEDVALUE('Table'[Month])
    )
)

RAW MISS = CALCULATE (
    COUNT ( Query1[Priority] ),
    FILTER (
        Query1,
        Query1[SLA Status] = "EXPIRED"&&MONTH('Query1'[Call Closed])=SELECTEDVALUE('Table'[Month])

            
    )
)

And you will see that all the graphs have been changed by the selection of the slicer.

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hiii kelly

 matrix and the other two bar grahs are displaying as per the current month in the slicer but line graph is not displaing the visuals correctly its showing as dots for raw sla% and mit sla%

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi  Anonymous ,

     

    Sorry for the late reply!

    Modify your measures for M.SLA%1 and RAW_SLA%1 as below:

    M.SLA% 1 = 
IF(MONTH(MAX('Query1'[Call Closed])) <= SELECTEDVALUE('Table'[Month])
            && MONTH(MAX('Query1'[Call Closed])) >=SELECTEDVALUE('Table'[Month])-2,
CALCULATE (
    [M.SLA%],
    FILTER (
        ALL(Query1),
        MONTH('Query1'[Call Closed]) <= SELECTEDVALUE('Table'[Month])
            && MONTH('Query1'[Call Closed]) >=SELECTEDVALUE('Table'[Month])-2
            && Query1[Call Closed].[Year] = YEAR ( TODAY () )
    )
),BLANK()
)
    RAW_SLA% 1 = 
IF(MONTH(MAX('Query1'[Call Closed])) <= SELECTEDVALUE('Table'[Month])
            && MONTH(MAX('Query1'[Call Closed])) >=SELECTEDVALUE('Table'[Month])-2,
CALCULATE (
    [RAW SLA%],
    FILTER (
        ALL(Query1),
        MONTH('Query1'[Call Closed]) <= SELECTEDVALUE('Table'[Month])
            && MONTH('Query1'[Call Closed]) >=SELECTEDVALUE('Table'[Month])-2
            && Query1[Call Closed].[Year] = YEAR ( TODAY () )
    )
),BLANK())

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!