cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
reddy421 Frequent Visitor
Frequent Visitor

Sales by Category if Items fall under Multiple Categories

I Created a Dashboard using PowerBI and It is working fine.
I have Sales, Departments, Classes, Items and it is fine till now.
Now I want to add Categories to my Dashboard.
But the problem I am facing is one Item can fall under Multiple categories. ( Sample data shown below)
I am planning to Keep Category as a slicer in my Dashboard.

1.png
Can someone guide me on this, please?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Sales by Category if Items fall under Multiple Categories

Hi @reddy421 

As tested, even one Item falls under Multiple categories, i can use "category" column in the slicer.

1.png2.png

What expected result do you want?

Do you want the "category" to group based on the same item?

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

reddy421 Frequent Visitor
Frequent Visitor

Re: Sales by Category if Items fall under Multiple Categories

I have a relationship between Item Dimension and the category dimension( on Item ID)
fyi.. In the pic shown below category is RA_UDA_V and Item Dimension is RA_DIM_ITEM_MASTER_V

But as soon as I drop the Category column to the table I am getting the below error.

1.png  

2.png

I tried to put the Category in the Slicer but I don't see that getting reflected.

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 129 members 1,431 guests
Please welcome our newest community members: