Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
So, I'm working with power bi with a dataverse data source, on this data source I have a choice type column that stores a string value, I have a total of 37 choices on this column, when I make a report using it, it displays the number instead of string value, is there a way to convert this numbers to a specific text string?
For example, when the number 1 shows I would like to display "Label 1", when number 2 shows I would like it to display "Label 2" and so forth.
@FRodriguez , You have to create a new column
Label = "Label " & [Number column]
Just to make it text you can change data type as text
Im not sure that this would work, a single record may have several labels, so for example a record may display "2.4,6" indicating that choices 2, 4 and 6 were made on that record.
I would, it needs to show in that case "Text Sample", "Other text sample", "Other more different text sample" all 3 as separate values
I tried using a switch function but it does not seem to like mixing integer with strings
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |