Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Which is the best method in power bi to categorize LAPW-Walkin Enquiry and LAPI,LAPB&LAI-Digital Lead without making changes where the data gets updated on its own?
Which is the best method to create alias values null-No Input 1-Hot, 2-Warm & 3-Cold without making changes where data gets updated on its own?
Hi @arjuns0028 ,
Your question is how to add categorized fields in Power BI? If yes, then you can utilize Power Query Editor to dynamically transform and categorize your data.
You can add a custom column, for example:
if [YourColumnName] = "LAPW" then "Category A"
else if [YourColumnName] = "LAPI" then "Category B"
else if [YourColumnName] = "LAPB" then "Category C"
else "Category D"
If I have misunderstood your needs, please feel free to contact us. Can you attach some sample data to illustrate your problem, preferably with the expected output as well, please.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
I mean data getting updated
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |