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.
Hi, is it possible to manually create alias values for values in a column (in Report view)? An example here would be for gender:
Gender
1
2
I would want to alias "Female" for 1, and "Male" for 2, so that "Female" and "Male" would show up in my reports, rather than 1 or 2.
In Tableau, this would be done by right clicking the Gender dimension, and selecting 'Aliases...'.
Solved! Go to Solution.
Once you've got your new GenderAlais column, you can clean up by hiding the old Gender column by right clicking on that column in the 'Fields' bar and clicking 'Hide'. This should keep your table looking neat and trim.
You can create a calcuated column to do this:
alias = IF([Gender] = "Male", 1, 2)
Hey yep thanks for the suggestion! That works, but it leaves you with a messy working environment if you have to keep creating new columns.
Once you've got your new GenderAlais column, you can clean up by hiding the old Gender column by right clicking on that column in the 'Fields' bar and clicking 'Hide'. This should keep your table looking neat and trim.
Great shout, why didn't I think of that! Brain is switched off today 😉
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 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |