Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
how to filter rows from a table type
1
2
3
4
using a list column type
1,2,3,4
in another table using dax functions?
ex: select value 1,3 in list and show
1
3
in table rows
The tables do not have any data relationship and all data is text type.
Solved! Go to Solution.
@Felipepbiplis As you mentioned there is no relation between table , A Nice way to solve this these using relationships with bridge table introduced between them and use that to get best out of the Power BI Modelling
However Alternately you can create measure to pass one selected value from one visual to other and use that to apply filters on the other in Filters pane or play bit with visual interactions
Here is DAX which can help you
1. Selected Value = SELECTEDVALUE(TAble1[Profiles],"No filter")
2. If filtered =
-------------------------------------------------------------------------------------------------------------------------------
Good day, amigo! Have I provided the solution? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?
@Felipepbiplis As you mentioned there is no relation between table , A Nice way to solve this these using relationships with bridge table introduced between them and use that to get best out of the Power BI Modelling
However Alternately you can create measure to pass one selected value from one visual to other and use that to apply filters on the other in Filters pane or play bit with visual interactions
Here is DAX which can help you
1. Selected Value = SELECTEDVALUE(TAble1[Profiles],"No filter")
2. If filtered =
-------------------------------------------------------------------------------------------------------------------------------
Good day, amigo! Have I provided the solution? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?
@Felipepbiplis I tried to understand what you posted , Correct me if i am wrong
I am assuming you already expanded your original list in to rows
if not then do expand it in Power Query as below
Then use the simple Filter using DAX to create a new Table
Also replace "Table containing list" with the name of your original table , and replace column "Original List" with the name of that column.
Hope it Helps
Okay, I'll try to explain better.
There are two datatables in the power bi and
the tables have no relationship and all data is text type, tables below:
table1
Names | Profiles |
Adrian | ABC |
Rick | ABC,XYZ |
Jhon | ABC,XYZ,UVZ |
Mike | ABC,XYZ |
table2
Ruler | Valor1 | Valor2 |
ABC | 1a | 3c |
XYZ | 2b | 3b |
UVZ | 1a | 2d |
I'm going to place the two tables in a common table visual on the dashboard.
When I click on a name in the table 1 visual, I want table2 to filter and show the filtered profiles rule corresponding to the name that was clicked.
example:
If I click on Rick in table1
table2 will look like this
Ruler | Valor1 | Valor2 |
ABC | 1a | 3c |
XYZ | 2b | 3b |
thanks!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
30 | |
27 | |
24 | |
22 |