Categorised data in PowerBi

0 votes

I'd like some advice on how to categorize/group data in PowerBi.

For example, I set up a conditional column in Power Query to achieve the results seen in the "Group" column by saying if ID is 8304, then Group B, and if ID is 8660, then Group F — but the database is large, and I'm already experiencing performance issues when trying to set up a report based on individual Groups; the data takes a long time to load.

Is there a better or more efficient way to group data?

ID Group
8015 A
8020 A
8229 A
8304 B
8389 B
8391 C
8414 D
8421 A
8469 A
8572 A
8619 F
8660 F
8663 J
9102 A
9104 K
9120
Apr 26 in Power BI by Neha
• 8,940 points
95 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

0 votes
1 answer

How to import data model from Excel in PowerBI?

You may try to divide your data ...READ MORE

answered Oct 22, 2020 in Power BI by anonymous
• 65,890 points
894 views
0 votes
1 answer

R scripts for Importing Data in powerBI?

There may be times when you don’t ...READ MORE

answered Nov 11, 2020 in Power BI by Gitika
• 65,890 points
618 views
0 votes
1 answer

Categorised data in Power BI

Use a helper table to store these ...READ MORE

answered Feb 8 in Power BI by CoolCoder
• 4,360 points
104 views
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,570 points
12,101 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,570 points
6,174 views
+1 vote
1 answer

Show the latest value in PowerBi from ASA

Best you can do right now is ...READ MORE

answered Oct 25, 2018 in Power BI by Surendra
1,091 views
0 votes
1 answer

Which one should I choose Tableau or Power BI?

Hi Grim, Both the BI tools - Tableau ...READ MORE

answered Apr 6, 2018 in Tableau by ghost
• 1,790 points
336 views
0 votes
1 answer

Error:connecting to Azure SSAS server in Power-BI through Import mode

If I understand correctly, you're connecting to ...READ MORE

answered Nov 9, 2018 in Power BI by Upasana
• 8,620 points
1,758 views
0 votes
1 answer

DAX : Occurrences of "count"

Try this for creating a calculated column ...READ MORE

answered Nov 22, 2018 in Power BI by Upasana
• 8,620 points
4,234 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,223 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP