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,
I am using a calculated field in a matrix preview, with the "See records" option enabled. When the user right clicks on a number and selects "See records" then they are taken to the underlaying data which consists of all columns present in the table that the calculated field is held in, as well as columns from other tables that are used in the field's DAX formula. I'm getting way to many columns (about 50) which is overwhelming the user - please can you tell me how to reduce the number of columns visible when a user chooses to "See records"?
Thanks,
CM
Solved! Go to Solution.
Ahh found it, the columns showing in the "See records" drilldown can be removed in the same way normal visualation rows / columns can be added/removed. So just click on the "x" to remove a column
Ahh found it, the columns showing in the "See records" drilldown can be removed in the same way normal visualation rows / columns can be added/removed. So just click on the "x" to remove a column
But is there a way to have those columns 'stick' so that when the user does a See Records again they see the same columns? I don't want to have he user continually remove columns each time they See Records.
Hi @mhambalekI think the matrix preview has been removed from the latest Power BI release and the standard matrix does not allow "See Records" so I think you question is no longer relevent?
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |