cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

Look up value

Hi 

i wish have result on selection of bar graph, if i select city in graph and  result shoul be like below 

 

 

if i select Pune then result "Yes" and if i select Mumbai then "No"

1 ACCEPTED SOLUTION

Accepted Solutions

@Amardeep100115 that should be easy, just create a measure for badge reader

 

Has Badge Reader Measure = 
IF ( HASONEVALUE ( Table[City] ), MAX( Table[Has Badge Reader] ), "SELECT A CITY" )

 

Put above measure in a card visual and it should work.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

4 REPLIES 4
Super User IV
Super User IV

@Amardeep100115 can you provide some more details and sample data not sure what you are referring too?

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Super User IV
Super User IV

@Amardeep100115 , not very clear , but you need something like

SWitch(true(), max(Table[City]) ="Pune", "YES",max(Table[City]) ="Mumbai", "No")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I wish to filter data on selection of bar in bar graph and results should be in card visual like values highlighted in green

 

hope i ma clear on my query

 

 

Sample Data 

 

 

Annotation 2020-07-21 202209.jpg

@Amardeep100115 that should be easy, just create a measure for badge reader

 

Has Badge Reader Measure = 
IF ( HASONEVALUE ( Table[City] ), MAX( Table[Has Badge Reader] ), "SELECT A CITY" )

 

Put above measure in a card visual and it should work.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors