Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello,
I'm having a requirement to sort a matrix by a custom column named "Sort by", but the users don't want to see the value of this measure when they export data.
"Sort by" is a custom measure created to dynamically sort the matrix by user selection.
Dax code is
SWITCH(SELECTEDVALUE('Sort By'[Sort By]),
"Sales" , [Sales],
"Cost" , [Cost],
"Revenue" , [Revenue])
User can select from a slicer which metric they want to sort the matrix (Sales/ Cost/ Revenue).
I can hide the value of "Sort by" in matrix visual, but cann't find any way to hide value in export data. Please help.
Hello everyone,
Is there anyone has new idea for my issue? It's required to export data from the matrix, but the Sort By value must be 0 or hide from user.
By doing this, the exported data won't include the values of the Sorting Measure, as you're using a separate table for export that doesn't include this measure.
Remember to adjust the column names and table references according to your actual data model. This approach allows you to control what gets exported while still using the Sorting Measure for sorting in the matrix visual.
Hello,
To achieve your requirement of sorting a matrix by a custom column ("Sort by") and not displaying the measure value in the exported data, you can follow these steps:
Create a Sorting Measure:
Hide the Sorting Measure in the Matrix Visual:
Create a Dummy Table for Export:
Export the Dummy Table:
Thank you for your solution, but my user used to export data directly from the matrix, is there any other way to achieve the requirement with data exported from matrix?
And if I create another table for export, the data will not be sorted as desired when not including the Sort By measure.
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
88 | |
83 | |
76 | |
49 |
User | Count |
---|---|
146 | |
137 | |
109 | |
68 | |
55 |