Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to use the slicer result to dynamatically show the estimation of expense, but get stuck on how to use the slicer result.
my design is to add a column in the table (or in other table is okay) with formular: Selected = if ( the cell of Name is selected, 1, 0); then I can do many things based on the new added column.
slicer table:
Name
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
Hey,
unfortunately it's not possible to use selection from slicers to populate columns in tables, this is because calculated columns are evaluated during the refresh of the data model.
Slicer are a UI component as any other visual, that interacts with the model (the refreshed model), so for this reason you just can use measures.
Maybe you can describe one of the many things you want to do, this makes things a lot easier to provide further assistance.
Regards
Tom
Hi, Tom
Thanks for your help.
the whole thing I want to do is to estimate the budget of different people with one dynamic element "location" to see the influence of location changes and determine the best location arrangement accordingly.
I have 13 people (Table 2), locating in two locations (column location in Table 2 should be calculated whether selected or not in Table 1). The final result of Column expense will vary depending on the column "location" in Table 2.
the rough column formulas:
Table 2 [location] = if (table 1[Name] is selected, "South", "North")
Expense = Cost in NonAsia * # in NonAisa + Cost in Asia * # in Asia + if (Table 2 [location] = "south", Cost in North * # in North, Cost in South * # in South)
Table 1 | Table 2 | |||||||||||||
Name | Name | # in Asia | # in NonAsia | # in South | # in North | Location | Table 3 Location | Round Trip Flights | Hotel | Meal | Nights | Cost | ||
A | A | 1 | 8 | 12 | North | NonAsia | 2000 | 200 | 75 | 5 | 3375 | |||
B | B | 1 | 2 | 2 | South | Other | 400 | 150 | 50 | 5 | 1400 | |||
C | C | 1 | 5 | 3 | North | North | 400 | 150 | 50 | 5 | 1400 | |||
D | D | 1 | 2 | South | South | 400 | 150 | 50 | 5 | 1400 | ||||
E | E | 2 | North | Asia | 580 | 200 | 75 | 5 | 1955 | |||||
F | F | 3 | 3 | North | ||||||||||
G | G | 1 | 3 | North | ||||||||||
H | H | 3 | North | |||||||||||
I | I | 3 | 1 | North | ||||||||||
J | J | 1 | North | |||||||||||
K | K | North | ||||||||||||
L | L | 2 | North | |||||||||||
M | M | 4 | North |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |