Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
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)
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.
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?
Hi @jamesfry1 ,
Could you pls share your pbix file ,remember to remove confidential data.
Best Regards
Lucien
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
74 | |
57 | |
40 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |