[Power BI] Splitting Excel data into two different collumns

PRATA Jose (EXT) 1 Reputation point
2022-05-13T15:14:14.303+00:00

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.

201809-image.png

201820-image.png

It should only display this ones:

201757-image.png

Community Center | Not monitored
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2022-05-13T15:24:27.883+00:00

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and 145510-image.png if the reply is helpful--

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.