Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Filtering one value not other in same visual with the help of slicer

Hi all,

 

One visual has line and bar values. There is one slicer.

Is it possible in Power BI that when I change the slicer value, bar values remains constant while line value gets changed.

 

Please let me knoe if there is any such kind of solution possible.

 

Thanks in advance!!

@Anonymous @Anonymous 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Mate, with a correct design everything is possible. That should go without saying.

 

The easier way to do this is to create a measure for the bars that is insensitive to the selections in the slicer. There might be other options but all depends on how your model is built and what relationships there are in there.

 

Best

Darek

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

To be clear, like @Anonymous said, you may define measures,
MeasureofLine = Calculate( Sum( 'LineTable'[Column]) )
MeasureofBar = Calculate( Sum( 'BarTable'[Column]), ALL( 'SlicerTable' ) )

-- or depend on your dashboard design you may use ALL( 'SlicerTable'[SlicerColumn] ) 

-- it will be good to have look at ALLSELECTED and ALLEXCEPT

 

Anonymous
Not applicable

Mate, with a correct design everything is possible. That should go without saying.

 

The easier way to do this is to create a measure for the bars that is insensitive to the selections in the slicer. There might be other options but all depends on how your model is built and what relationships there are in there.

 

Best

Darek

Anonymous
Not applicable

Yeah, I have tried it the same way and it gets resolved. 

 

Still Thanks!! 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors