Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
106 | |
93 | |
69 |
User | Count |
---|---|
167 | |
132 | |
130 | |
96 | |
91 |