Forum Discussion
Resolver Islicer 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 | Part Three |
| Area One | Down | Name 1 | Base Management | ||
| Area One | Down | Name 2 | Base Management | Production Shop | Flow Assurance |
| Area One | Up | Name 3 | Production Shop | Base Management | |
| Area One | Up | Name 4 | Production Shop | Process Engineer | |
| Area One | Up | Name 5 | Flow Assurance | Production Shop | |
| Area One | Left | Name 6 | Production Shop | Flow Assurance | |
| Area One | Left | Name 7 | Production Shop | Flow Assurance | |
| Road | Right | Name 8 | Base Management | Production Shop | |
| Road | Right | Name 9 | Base Management | Gateway | Flow Assurance |
| Upper Deck | Right | Name 10 | Base Management | Production Shop | |
| Upper Deck | Right | Name 11 | Base Management | Production Chemist | Process Engineer |
for example.
if activity "Name 1" is selected , corresponding "part one" value is blank, the result should display as "no results"
if activity "Name 2" is selected , corresponding "part one" value is "Base Management"/ any value in it, the result should display as table of its value
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.
4 Replies
- Shishir22
Solution Sage
Hello sanjanarama ,
As per my understanding from above post you are getting blank for Part One and you want to replace it with "No Results"Use below calculated column in place of Part One.
Column = if(ISBLANK(Data[Part One]),"No Result",Data[Part One])Please mark it as solution if it resolves your issue. Kudos are also appreciated.
Cheers,
Shishir
sanjanaramaShishir22 no, i have edited my requirements. please view that again and help me
- Shishir22
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.