cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
unkCandy
Helper I
Helper I

Get the Filtered values based on a bar chart

Hello Community, 

I am working on a measure to get me the filtered ids based on a person and put them in a table to get the whole process of the filtered ids. 

 

My table has three values: 

  1. Id
  2. The activity presents what has been done for the id
  3. A person who has done the activity

My visuals are as follow:

  1. Table includes all the data: id, activity, Person
  2. Bar chart presents the count of activity by Person

unkCandy_0-1669730738540.png

I want to be able to select a person, for example, Rick and instead of getting only the activities done by Rick, I want to get ids that Rick is included in and shows all activities of these ids.

unkCandy_1-1669730776488.png

The result will look like this: 

unkCandy_2-1669730818123.png

I tried to use the SelectedValue function, but it doesn't show me anything. Is there any way to implement this in Power BI? 

Thank you.

 

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @unkCandy 

Please try this ,

Measure = 
var _person=SELECTEDVALUE(Person[Person])
return IF(MIN('Table'[Id]) in SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[Person]=_person),"ids",[Id]) ,1,0)

vxiaotang_0-1669801990946.png

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

v-xiaotang
Community Support
Community Support

Hi @unkCandy 

Please try this ,

Measure = 
var _person=SELECTEDVALUE(Person[Person])
return IF(MIN('Table'[Id]) in SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[Person]=_person),"ids",[Id]) ,1,0)

vxiaotang_0-1669801990946.png

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.