Categorised data in Power BI

0 votes

I am looking for a suggestion on how to categorised/group data in Power BI.

For example, I have set up a conditional column in Power Query to achieve the results seeing in “Group” column by saying if ID is 8304 then Group B, if ID is 8660 then Group F -- but the database is large and I am already facing a performance issue when trying to set up a report based on individual Groups, it takes long to load the data.

Is there any alternative or better approach 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 A
Feb 8, 2022 in Power BI by surbhi
• 3,810 points
404 views

1 answer to this question.

0 votes
Use a helper table to store these connections instead of a conditional column.

By linking the two tables, you may add the information to your main table.
answered Feb 8, 2022 by CoolCoder
• 4,400 points

Related Questions In Power BI

+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
13,386 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
2,512 views
0 votes
1 answer

How to show filtered vs total data in power BI?

Hi sindhu, Follow below steps to show filtered ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 33,030 points
4,226 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17, 2019 in Power BI by Avantika
• 1,520 points

edited May 17, 2019 by Omkar 7,069 views
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,910 points
1,533 views
0 votes
1 answer

Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

answered Sep 28, 2020 in Power BI by Gitika
• 65,910 points
1,253 views
0 votes
1 answer

DAX EARLIER() function in Power Query

Solutions in the code below. Notice that ...READ MORE

answered Oct 1, 2020 in Power BI by Gitika
• 65,910 points
2,455 views
0 votes
1 answer

DAX Userelationship function

 You need a way for the measure ...READ MORE

answered Oct 5, 2020 in Power BI by Gitika
• 65,910 points
818 views
0 votes
1 answer

What is DAX in Power BI?

DAX is a programming language used in ...READ MORE

answered Feb 4, 2022 in Power BI by CoolCoder
• 4,400 points
438 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