Forum Discussion
Display table details based on click on another table
I have previously used this wonderful guide to hide/show data on my report: Show or Hide a Power BI Visual Based on Selection - Excelerator BI However, I now have two tables that are linked (data...
I fixed this by taking filters off and then changing the table interactions (so it doesn't automatically filter now, and therefore only displays results when it is clicked on).
Hi Anonymous ,
Do you want to display others when no content is selected?
You can make an IF statement judgment after your measure
1. Create some dataļ¼
2. Create measure.
Measure =
var _1=SELECTEDVALUE('Table'[countries])
return
IF(MAX('Table'[countries])=_1,
MAXX(FILTER('Table','Table'[countries]=_1),'Table'[info]),
"no select")3. Result.
When selecting, display the corresponding value.
When it is not selected, "no select" is displayed.
If the result does not meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.