How to design a table with 2 filter data

[cristianj]

Hello 

I am new to PowerBI and i have a question about doing something like that

Metrics             |  Interval 1                                  | Interval 2

First Topic        | Value relative to first interval | Value relative to second interval 

Second Topic  | Value relative to first interval | Value relative to second interval 

Third Topic      | Value relative to first interval | Value relative to second interval 

....

the filtered would be data.(the values would be loaded by querry from postgresql)

thank you for the answers

[cristianj]

and i want to have more rows, with different indicators

[v-chenwuz-msft]

Hi @cristianj,

Yes, you need unpivot this table first and then add the [Attribute] to columns of matrix table. [Metrics] in Rows.

The result of unpivot should like this:

The matrix table

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@cristianj , If interval value is (interval1 , interval2 ) in in the row, We can unpivot the data in power query

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

or can use matrix visual with interval on the column

[cristianj]

Hello ,

The data filter is not in the table, it would be chosen from the interface of power bi