Forum Discussion
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"
Anonymous 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.⚡
4 Replies
Anonymous can you provide some more details and sample data not sure what you are referring too?
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
Anonymous 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.⚡
Anonymous , not very clear , but you need something like
SWitch(true(), max(Table[City]) ="Pune", "YES",max(Table[City]) ="Mumbai", "No")
