Forum Discussion
matrix output using 2 slicer from same column
I have a Project table like this in power BI.
| project name | cost | start date |
| p1 | 300 | 12/12/2020 |
| p2 | 200 | 12/01/2023 |
| p3 | 100 | 09/01/2022 |
I want to give user two slicers to able able to compare any 2 projects and compare results in a matrix. For example he can select p1 and p4 in two diff slicers and can compare there start date and cost. There are 3 more slicers for each project selection like phase, their project id. There are other columns that I want in the output matrix that are calculated using fields from other table to which this main project table is connected.
output should look like
| project name | p1 | p2 | delta |
| startdate | date1 | date2 | 2 days |
| cost | 1000 | 2000 | 1000 |
| project end date | 01/01/2029 | 09/01/2028 | 178 days |
1 Reply
Anonymous , You need to have a slicer on one or two independent tables and then you need to create the required measures and use that in Matrix to display
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc
