Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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. 

 

i1i2i3Out

Germany

Trains

Station

Station 1

GermanyTrainsStationStation 1
JapanTrainsStationStation 6
NorwayTrainsStationStation 2
GermanyTrainsHas PassengersTRUE
JapanTrainsHas PassengersTRUE
JapanTrainsHas PassengersFALSE
NorwayTrainsHas PassengersTRUE

 

 

  • 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

  • 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.