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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
jamesfry1
Frequent Visitor

Controlling the fields when showing data point as table

Hi, my  issue is around controlling the data that you drill into when you have tables/graphs/charts showing summary statistics.  

EG,

I have a query that has brought in a number of pieces of data about some customers

 

I have made some tables and charts based on certain fields. EG I’ve done a graph showing the age categories of the customers like below

jamesfry1_0-1669889691170.png

 

 

What I want to be able to do in Power BI is to be able to drill into the data via the datapoints- by right clicking on the data and selecting show data point as table (like below screenshot)

jamesfry1_3-1669889736243.png

 

 

 

And then I want to be able to control which fields will appear in the below table when you show data point as table (at present it will show every field from my source query) and I want to be able to control this depending on the visual eg only have a few  key fields showing.

jamesfry1_2-1669889691212.png

 

 

Presently, if I amend the table in the visualisations tab while I’m viewing the datapoint table it will revert back to default and show everything once I leave the data point table and go back to the report and click on the datapoint again.  

 

Is it possible to control what fields are  in the datapoint table and save it so that is what shows when a user clicks into it that particular datapoint?  

1 REPLY 1
v-luwang-msft
Community Support
Community Support

Hi @jamesfry1 ,

Could you pls share your pbix file ,remember to remove confidential data.

 

 

Best Regards

Lucien

Helpful resources

Announcements
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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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