Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 table
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?
Solved! Go to Solution.
@Anonymous , I think changes on show as table can be saved. I doubt show data point as table
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 35 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |