Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Muliple Slicer Selection based on column

Hi, 

 

I am trying to make a slicer which can turn off/on certain effects which were detected. For example: You have a truss with grapes. 

The computer has measured that truss one has one green grape, eight red grapes and 1 blue grape. Also the computers measures how many grapes have certain issues which make them not sellable. 

 

I want a slicer which filters every truss by the if this problem of colour is available in this truss. 

So in the case of this example, if i select "blue" Truss one and  Three will show. Truss two and four will be filtered out. 

 

I hope my questions is clear :D, any questions I will be happy to answer!

TrussRedBlueGreenProblem 1

One

8111
two4050
Three2513
Fout1091
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    I found a solution by creating a new colum measuring if the statement is "problem is there" or null. Using a slicer with this new colum and filter out the Null values will almost complete the job.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your reply, but the dataset is to big to do an easy transform (unpivot comuls). The dataset must be in this position to be working fine. Also it would be nice is some new problems were added, that adding this to powerbi wouldn't be that difficult.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I found a solution by creating a new colum measuring if the statement is "problem is there" or null. Using a slicer with this new colum and filter out the Null values will almost complete the job.