Forum Discussion

mjklare's avatar
mjklare
Regular Visitor
3 years ago
Solved

Adding text to a filter

I have a report that I am building.  I have a few filters on it that work great.  But.  For example I can filter sales by a customer class.  So the customer classes are listed which are numeric like ...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    mjklare maybe add a new column in the model to assign the value/description:

     

    Class Description = 
SWITCH ( 
   Table[Class Code],
   10, "Dealer",
   20, "Rental",
   30, "Agent",
   "Other"
)

     

    👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

    If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

parry2k's avatar
parry2k
Super User
3 years ago

mjklare maybe add a new column in the model to assign the value/description:

 

Class Description = 
SWITCH ( 
   Table[Class Code],
   10, "Dealer",
   20, "Rental",
   30, "Agent",
   "Other"
)

 

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️