Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
PowerBI Desktop, Version: 2.56.5023.942 64-bit (March 2018)
I have downloaded a pbix file and opened it in PowerBI Desktop. The data source is a PowerBI Service and the lack of Data or Relationship tabs indicates it's a SSAS solution.
When I put some of the data (accounts) into a matrix and sort by the account name it actually sorts by the account number. This leaves the account names in a seemingly random order. I want to confirm that the model is set to sort by another column. Ideally I'd be able to turn this off.
Is there a tool I can use to view the queries? Apparently I can't use DAX Studio because it only works with imported models.
Is there a means of turning off "sort by another column" when I don't have access to the model?
Clicking on the menu at the top to sort asc or desc sorts it by the associated field rather than the displayed field.
As you both have suggested, I'm going to have to go back to the original developer.
I don't think you can do this. The documentation says "You can create report level measures in the Power BI Desktop, but all other query and modeling features are disabled when exploring live data". Can you reach out to the author of the model?
You can go to Power Query Editor->Advance Editor to check the M using to load the data and then modify the Order.
How do I get there without access to the Data or Relationships tabs?
Except that it's not my cube. It's a PowerBI Service.
Surely there's a way to say, "that's a great recommendation, but I don't want to sort by that field. Thanks all the same."
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |