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.
Hi all,
I created 2 tables to show every incident (left) and the describtion (right). What I want to show is a blank table on the right , and if any row of left table is selected, the description will be shown up. How can I achive the result?
Thank you in advance!
Solved! Go to Solution.
Hi @Anonymous ,
Could you please tell me that is your problem solved? As @TomMartens said, the ISFILTERED function is the key.
However, you also first have to make sure that there's no relationship between your two table visuals. About more details of relationships, please refer to
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
And then create a measure.
Measure = IF(ISFILTERED('Table'[Number]),1)
Put the measure into the visual-level filters, and set up show items when the values is 1.
Below is the result, when any row of the left table visual is selected, the right visual will display the data.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Could you please tell me that is your problem solved? As @TomMartens said, the ISFILTERED function is the key.
However, you also first have to make sure that there's no relationship between your two table visuals. About more details of relationships, please refer to
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
And then create a measure.
Measure = IF(ISFILTERED('Table'[Number]),1)
Put the measure into the visual-level filters, and set up show items when the values is 1.
Below is the result, when any row of the left table visual is selected, the right visual will display the data.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @Anonymous ,
you can try to create a measure, that is leveraging the function ISFILTERED: ISFILTERED – DAX Guide in combination with a relationship column if a relationship exists.
Hopefully, this provides you with an idea of how to tackle your challenge.
Regards,
Tom
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |