Forum Discussion
Filtering a column with separate slicers and comparing the results from each
My goal is to compare different metrics from the same column using separate slicers and a bar chart.
Say I have a 'Table' with input columns 'Table'[i1], 'Table'[i2], 'Table'[i3] and an output column, 'Table'[Out].
Let's say I also have 2 slicers (A and B) which allow me to select specific inputs for i1, i2, and i3. I want to make a bar chart with the values in the Out column after being filtered by slicer A as the X-axis and those filtered by slicer B as the Y-axis. This is just what I've thought of so far, but I'm open-minded. How would you compare the different types of data in the Out column based on the first 3 columns? See example table below.
| i1 | i2 | i3 | Out |
Germany | Trains | Station | Station 1 |
| Germany | Trains | Station | Station 1 |
| Japan | Trains | Station | Station 6 |
| Norway | Trains | Station | Station 2 |
| Germany | Trains | Has Passengers | TRUE |
| Japan | Trains | Has Passengers | TRUE |
| Japan | Trains | Has Passengers | FALSE |
| Norway | Trains | Has Passengers | TRUE |
Anonymous , Not very clear.
Are looking for something like this Compare two Brands: https://youtu.be/exN4nTewgbc
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
1 Reply
- amitchandak
Super User
Anonymous , Not very clear.
Are looking for something like this Compare two Brands: https://youtu.be/exN4nTewgbc
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.