Individual filter grouping

[joshua1990]

Hi experts!

I have a flat table in this structure:

Article	Filter 1	Filter 2	Filter 3
A	TRUE	WRONG	TRUE
B	WRONG	TRUE	WRONG
C	WRONG	TRUE	WRONG
D	WRONG	WRONG	TRUE

In the report itself I have 3 slicers to filter on the specific filter (1, 2 or 3).

Is there any way to consolidate those 3 filters?

Like an hierarchy of

• Filter 1
  • Wrong
  • True
• Filter 2
  • Wrong
  • True
  • ...

[amitchandak]

@joshua1990 , One way is to unpivot the tables

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

Or create a single table with these values

and then userelationship to create measures

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...