Forum Discussion
elflakoconk
5 years agoHelper II
Filter blank rows in visuals
Hello all I have meny tables with a one on one relation using id field, for example this 2: and I have 2 visuals, 1 donut chart and 1 table data I need to by clicking the don...
- 5 years ago
elflakoconk , as val2 is column(aggregated) means measure, it will not filter data on click.
You can unpivot three columns val1, val2, val3, that will make the dimensions/parameter and then you can drill
refer
v-henryk-mstf
5 years agoCommunity Support
Hi elflakoconk ,
For donut chart visual, the added field of Values is a specific field type, such as max, min, average, etc., so clicking any part of donut chart visual will not interact with the table and affect it. If you really need this requirement, you can post your idea here: Ideas - Microsoft Power BI Community
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.