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

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

View solution in original post

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

 

Still Thanks!! 🙂

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.