Sales by Category if Items fall under Multiple Categories

[reddy421]

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.

Can someone guide me on this, please?

[v-juanli-msft]

Hi @reddy421 

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

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]

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.

  

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