Forum Discussion

sanjanarama's avatar
sanjanarama
Resolver I
4 years ago
Solved

slicer selection result

I have a dropdown slicer for activity column. if any activity is selected then results should be displayed based on column "Part one" column.   Threat Node Activity Part One Part Two Pa...
Need Help
  • Shishir22's avatar
    Shishir22
    4 years ago

    Hello sanjanarama ,


    I dont think that will be acheivable directly.

    Though you can try workaround-

     

    Apply visual level filter on visual as Part One not equals to Blank.

     

    Try to create a measure as below, add it into card visual and place it behind table visual keeping table visual backgournd as off.

     

     

    Measure = if(HASONEVALUE(Data[Part One]) && min(Data[Part One])= BLANK(),"No Results as Part one is blank","")

     


    Turn off the Category label to off and place this card visual behind table visual.

     

sanjanarama's avatar
sanjanarama
Resolver I
4 years ago

Shishir22 no, i have edited my requirements. please view that again and help me

Shishir22's avatar
Shishir22
Solution Sage
4 years ago

Hello sanjanarama ,


I dont think that will be acheivable directly.

Though you can try workaround-

 

Apply visual level filter on visual as Part One not equals to Blank.

 

Try to create a measure as below, add it into card visual and place it behind table visual keeping table visual backgournd as off.

 

 

Measure = if(HASONEVALUE(Data[Part One]) && min(Data[Part One])= BLANK(),"No Results as Part one is blank","")

 


Turn off the Category label to off and place this card visual behind table visual.

 

  • sanjanarama's avatar
    sanjanarama
    Resolver I
    4 years ago

    thank you. it worked