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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Changing and Saving Visualization Changes in Data Point Table

Hello, I've been using Power BI to display information similar to Pivot tables in Microsoft Excel. I've recreated what one of my excel Pivot tables would look like, but in BI. My problem is that when I try to drill-down on the data, I cannot get the data point table to display everything I need in addition to the order I need it in. When I add everything to the visualizations pane and correct the order in which I need the data to display, once I return back to the report and open another data point table, or even the same one all my changes are reverted. I've done some googling on this subject and have seen other people have had this question as well, I just have been unlucky in finding a solution. 

Here I am on a matrix showing my data point tableHere I am on a matrix showing my data point tableHere I am moving the data in my visualizations to match the data point table. I want RITMNumbers to be displayed in the first column. Once I change all the values in the visualization to the places I want, I would like to be able to save this change somehow.Here I am moving the data in my visualizations to match the data point table. I want RITMNumbers to be displayed in the first column. Once I change all the values in the visualization to the places I want, I would like to be able to save this change somehow.

In the second Image I am moving a value to the front of the visualization to place it in the first column. If I got back to report and re-open the data point table, it does not save this change. How can I fix this?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , I think changes on show as table can be saved. I doubt show data point as table

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , I think changes on show as table can be saved. I doubt show data point as table

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.