[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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,982 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    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