Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Geims83
Microsoft Employee
Microsoft Employee

Drill through with hidden field?

I have a Table visual:

 

IdNameDetails.....
SomeOrribleGuidEntityName...
AnotherOrribleGuidAnotherEntityName...

 

And I have another page, with the full entity details, where I want to drill through from this Table visual.

I have set the Id in the drillthrough fields for the details page.

Everything works, BUT: is there a way to make it wotk without showing the Id column in the Table visual?

6 REPLIES 6
AdrianLock
Helper I
Helper I

While this is an old post.  if your drill through is producing a table  list I've just added coluns to the table but then made them 0 in width with blank as the title.  So that drill through still works but there is nothing anyone can see.

I'd love to know how you managed this - I can't find column title or width in the specific column settings. Whenever I try to collapse the column down manually each row gets very wide because of the text in the colum I'm trying to hide. Closest I've got at the moment is to move the offending field off the right hand side of the table, which does mean a horizontal scrollbar

Hi Josh all you need to do is make the title of the column a SPACE.  then you can make as small as space takes up character wise.

v-shex-msft
Community Support
Community Support

Hi @Geims83,

Nope, current you need include the drill through filter field into the raw visual or 'drill through' option will not display when you right-click on it.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

@Geims83 , I think you need to have one column from the drill page to drill down. Can you add one more member in the drill-through list on drill through the page. 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Hi @amitchandak ,

yeah I could add another field, but it doesn't solve the issue.

If I have more entities with the same name, in the details page I have to choose first/last etc for every field.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.