Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a table at UI having 10 columns out of which 8 are dimension and 2 are measures. When I select a row in that table ,
those 8 dimensions act as filters on others visuals on that page. My requirement is only out of those 8 dimensions only 2 dimension should impact other visuals on the oage when a row is selected in that table.
I tried to convert dimensions into measure(using selectedvalue, values) but it didn't work because those measures are text columns and it fails in one or another scenario.
Is there a ways to not to have impact of those 6 dimensions on others visuals when a row is selected in that table?
Regards
Vaishali
Solved! Go to Solution.
Hi @Vaishali04 ,
You may implement your demand by using Edit interactions feature, select the your Table visual firstly, go to Format-> Edit interactions, select the "no impact" icon for all of other visuals.
For example:
You can learn more: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Vaishali04 ,
You may implement your demand by using Edit interactions feature, select the your Table visual firstly, go to Format-> Edit interactions, select the "no impact" icon for all of other visuals.
For example:
You can learn more: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Vaishali04 , This default functionality. I doubt it can change. You can create a measure that ignores the other 6 filters and use that in other visuals.
Or You can try Drill Through. There you can set drill through parameter. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |