I have a problem with the Power BI slicer. I have a tables that looks something like this:
Table A:
| Date | Article A | Article B | Article C |
|---|---|---|---|
| 29. Nov | $29.99 | $129.99 | $13.99 |
| 30. Nov | $32.99 | $132.99 | $14.99 |
| 1. Dec | $29.99 | $135.99 | $17.99 |
| 2. Dec | $27.99 | $137.99 | $20.99 |
Table B:
| Date | Article A | Article B | Article C |
|---|---|---|---|
| 29. Nov | $32.99 | $135.99 | $11.99 |
| 30. Nov | $29.99 | $134.99 | $14.99 |
| 1. Dec | $27.99 | $132.99 | $20.00 |
| 2. Dec | $25.99 | $134.99 | $22.99 |
Now I would like to create a line chart that shows the date progression on the X-axis and the price on the Y-axis. This is working fine up to this point.
Now I want to insert two slicers.
Slicer 1: Table selection (options here are: Table A, Table B) Slicer 2: Product selection (options here are: Article A, Article B, Article C)
To do this I have already tried to create a relationship between the date columns. If I create a slicer and select the articles the solution is for example: $29.99, $32.99,... but thats not that i want. If I transver the Table I have to select every single Date, so thats also not the solution.
How can i do this? Can someone help me?
In Power Query, you should unpivot both tables on Article A to C columns, then add a custom column, then finally, Append the two tables.
With this data shape you'll have more flexibility with slicers/filters etc...