Forum Discussion
Display specific value to the dashboard
| name | value |
| lastname | administrator |
| [email protected] | |
| status | active |
| last name | last admin |
I have a table like above and I have display email id in the card of the dashboard. Please help to how should filter to display in the dashboard.
I need something like sql "select value from table where name='email'" the result should be displayed in the card for the visualization.
2 Replies
Hi Anonymous,
Lucky you that I know both Power BI and SQL 🙂
So for that querry in SQL Select "" from table where name = "" in Power BI you have the below option:
- select the chart go to filter type, choose advanced filtering and there you can select any option you want: for example you can choose to contain "whatever you want".
That should do your job.
Hope this helped and if yes please give a kudos and accept as solution.
Best regards
Alin Oprita
v-lili6-msftCommunity Support
hi Anonymous
You could create a measure by the formula
Measure = CALCULATE(MAX('Table'[value]),FILTER('Table','Table'[name]="email"))Then drag this measure into a measure.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-card
https://docs.microsoft.com/en-us/power-bi/desktop-measures
Regards,
Lin