Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Slicers using Grouped Data

Hello!

 

I have a dataset based on Commodities that I would like to be able to display data based on the selected group of commodities.

 

For example - I've grouped the below items according to their market

Dairy - cheese, milk, butter, oil

Soda - sugar, aluminum

Currency - USD, Canadian Dollar, Brazilian Dollar

 

I want to be able to have a slicer that, when selected, shows me the items in that grouping only. So if I select Dairy, I want to display cheese, milk, butter, and oil data.

 

Any help would be appreciated.

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@Anonymous,

 

Try this calculated column:

 

Group = 
VAR vItem = Table1[Item]
VAR vResult =
    SWITCH (
        TRUE (),
        vItem IN { "cheese", "milk", "butter", "oil" }, "Dairy",
        vItem IN { "sugar", "aluminum" }, "Soda"
    )
RETURN
    vResult

 

DataInsights_0-1645022971493.png

 

Create a slicer using the Group column.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
DataInsights
Super User
Super User

@Anonymous,

 

Try this calculated column:

 

Group = 
VAR vItem = Table1[Item]
VAR vResult =
    SWITCH (
        TRUE (),
        vItem IN { "cheese", "milk", "butter", "oil" }, "Dairy",
        vItem IN { "sugar", "aluminum" }, "Soda"
    )
RETURN
    vResult

 

DataInsights_0-1645022971493.png

 

Create a slicer using the Group column.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.