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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

View Records In A Table

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.

4 REPLIES 4
ankitpatira
Community Champion
Community Champion

@Anonymous Can you specify more detail? In table you already see records.

Anonymous
Not applicable

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.

Anonymous
Not applicable

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?

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors