Forum Discussion
How to display data filtered from imported table
Hi
I have a SQL Server table that I have connected to my desktop powerbi ( it has a local model ).
The table appears as a dimension/table called "AA_Data" and has columns called [ID] and [trace].
What I wanted to do is drag in both columns from AA_Data into a simple table on the desktop , but filter the data so we can display only one part of the table data.
So table looks like this as unfiltered data :
[ID] [trace]
X 1
Y 2
Z 3
But I wanted to filter out everything except Y and display this :
[ID] [trace]
Y 2
How could I do that please?
Thanks in advance
Hi Anonymous
Simple filter will do the job :
The pbix with the example is attached
If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly
9 Replies
ryan_mayuSuper User
Anonymous
you can try to add a filter to visual,page or report
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-report-filter?wt.mc_id=DP-MVP-5004616
- Ritaf1983
Hi Anonymous
Simple filter will do the job :
The pbix with the example is attached
If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly
- Ritaf1983
Hi Anonymous
measure_ = CALCULATE(sum('Table'[trace]), FILTER('Table','Table'[id]="Y"))The updated pbix is attached
If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly
v-pnaroju-msftCommunity Support
Thankyou, Ritaf1983, ryan_mayu, for your response.
Hi Anonymous,
We would like to check if the solution provided by Ritaf1983 and ryan_mayu has resolved your issue.
If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.
Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.Thank you.
- v-pnaroju-msft
Hi Anonymous,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.