cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dotdotdashboard
Frequent Visitor

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

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@dotdotdashboard , 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.



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@dotdotdashboard , 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.



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors