Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Was there any plans to have the option to view records via a table?
The latest update to view records via data points is awesome and I've used that as a workaround for the time being.
@Anonymous Can you specify more detail? In table you already see records.
Sure.
At the moment I've got what you might refer to as a summary table:
Sale Volume
Product 1 3
Product 2 4
Product 3 12
(I hope the formatting comes out how it looks in the editor).
But in the above example, I'd like to be able to click on (4) and see what the colour / sale price (full row details) of that data subset. It would be simliar to in Excel where you'd have a PivotTable and double click on one of the numbers and it would show you the full dataset relating to it.
I hope I've been able to explain that a bit better.
@Anonymous Using table visual you can click on Don't summarize on values and that will give you all the rows ( i think you already know that). If you'r after summary value and row level value both together you will have to use two seperate visuals. I am currently using column chart and then table visual underneath to show all the rows for the column user select on column chart. I dont think it is possible to hyperlink value and then drill down from it currently in a table visual.
Yeah, the 'Don't Summarize' option on the values doesn't give the level of detail I'd need for a partifular sub-set unfortunately but you're right I'm having to use two different visuals as a workaround. I've got the table so the data can be interpreted as well as the column chart so you can drill down and view sub-sets of the records. It was just more from an end user perspective where they've previously been trained to double click on values in a pivot table to bring up the sub-set where as now they need to click on chart / data point to get what they're after.
Hopefully this idea would be considered as future functionality?
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 20 | |
| 20 | |
| 12 |
| User | Count |
|---|---|
| 63 | |
| 56 | |
| 47 | |
| 44 | |
| 37 |