Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
Solved! Go to Solution.
@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
Create a slicer using the Group column.
Proud to be a 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
Create a slicer using the Group column.
Proud to be a Super User!
User | Count |
---|---|
84 | |
81 | |
64 | |
53 | |
45 |
User | Count |
---|---|
100 | |
48 | |
41 | |
39 | |
38 |