Display Data in Table/Matrix based on variable filters

[PantherusNZ]

I have a data dump of a large number of line items, and am trying to display them all in a single table based on various filters.

Each line item, among other things, has 4 colums I'm interested in - Priority, Response SLA, Restore SLA, Not-At-Fault - and I'm trying to display them all in a single table/matrix.  Priority is an integer from 1-5, Response and Restore SLA are Yes/No, Not-At-Fault is either Yes, No, or Requested.

What I'm trying to do is have the table broken down by Priority (for the row labels) and then the columns will be total, Response SLA = Yes, Restore SLA = Yes, Not-At-Fault = Yes or Requested -something like this:

but the best I can do is multiple matrices with each of those columes separately because as soon as I try to add more than one of them as columns or values the visual go haywire.  I can't just use filters because, for example, you might have Yes to Response SLA but No to Restore SLA, or vice versa, and both would need to show up in their respective columns.

I imagine it has to be calculated by Measures but I haven't been able to figure out how to build them yet - can anyone help me, please?

[Anonymous]

Hi @PantherusNZ ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PantherusNZ , You can unpivot the Response SLA ,Restore SLA  and Not-At-Fault. And then create a column of yes and using if or switch

https://radacad.com/pivot-and-unpivot-with-power-bi

[PantherusNZ]

Hi @amitchandak 

I'm trying to follow your instructions but I must be doing something wrong.

I selected the 3 colums and pivoted them but it just duplicated each row of data 3x with the 3 columns added with their yes/no values...I am either doing something wrong or just don't know where to go from there.

[PantherusNZ]

Thanks for that, I'll have a look into the pivot tool and see if I can produce what I need.