Forum Discussion

maqsud's avatar
maqsud
Icon for Helper III rankHelper III
6 years ago

Visualisation card should be blank until something selected in a slicer

I have data something like this:

'HRISData'

NewEmployeeCodeFull NameNewManagerCode
E157Brown MiaE010
E008Carter Michelle 
E216Smith LeighE008
E244Gill WhitneyE008

 

 

I want my Manager Name Card should be Blank until something is selected in Manager Code Slicer.

 

Manager Name Card without selecting Manager Code

 

 

Manager Name Card with selecting Manager Code

 

Thank you!

data protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

    • maqsud's avatar
      maqsud
      Icon for Helper III rankHelper III
      6 years ago

      amitchandak, I am trying the following measure to use for Manager Name Card Visual Level Filter.

       

       

      SlicerCheck = IF(ISFILTERED(HRISData[NewManagerCode]), HRISData[NewManagerCode] , BLANK())

       

      But this gives me the following error

      "A single value for column 'NewManagerCode' in table 'HRISData' cannot be determined." 

       

       

      I have found similar article but nothing seems to be working so far.

      • v-xuding-msft's avatar
        v-xuding-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi maqsud ,

        Please try like this:

        SlicerCheck = IF(ISFILTERED(HRISData[NewManagerCode]), MAX(HRISData[NewManagerCode]) , BLANK())

         

         

  • sanimesa's avatar
    sanimesa
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    maqsudSee if this measure works for you:

     

    Selected Manager Name = 

VAR managerCode = SELECTEDVALUE(HRISData[NewManagerCode])

RETURN CALCULATE(MAXX(ALL(HRISData), [Employee FullName]), HRISData[NewEmployeeCode]=managerCode)