Forum Discussion
How to design a table with 2 filter data
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
4 Replies
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
Hello ,
The data filter is not in the table, it would be chosen from the interface of power bi
and i want to have more rows, with different indicators
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.
