Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Splitting Excel data into two different collumns

Good afternoon,

 

I got into Power BI a week ago and I have been having some troubles with it.
I got a simple Excel database composed by Operative Systems, Servers, Number of the Error and Error Level.
Every machine has errors and it can either be one of the levels (4 or 5) or it can has both errors.
In my power BI matrix i got to have an option or something that whenever i select it will only display the machines that own both errors. All the other ones should disappear.
I will link both excel and power bi examples to make it easier to understand the problem.

 

 

 

 

And it should only display this ones:

 

 

 

Hope someone can help me.

Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    4 years ago

    Anonymous - This is the closest I could get. Hopefully it'll get you pointed in the right direction.

3 Replies

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    4 years ago

    Anonymous - This is the closest I could get. Hopefully it'll get you pointed in the right direction.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Unfortunately it doesn't work 😞
      It will either display all the values or none.
      Can it be a fault by my part sorting the parameters or idk.

      However thank you for the disponibility and hope you can help me solve this problem.