Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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
@Shishir22 no, i have edited my requirements. please view that again and help me
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.
thank you. it worked
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |