Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
hello everyone i made a field parameter table as shown here and added a new column type :
i added a slicer and added the "Type" column to it and made another slicer and added "Name" to it and i have something like
in this example, all fields of second slicer for "Video" are empty such as
i made a measure
FB Campaign Switch Measures =
SWITCH(
SELECTEDVALUE('PM For FB Campaign'[Order]),
0, [FB Campaign Impressions],
1, [FB Campaign Link Clicks],
2, [FB Campaign Messages],
3, [FB Campaign Reach],
4, [FB Campaign Click Through Rate],
5, [FB Campaign Landing Page Views],
6, [FB Campaign Messaging Rate],
7, [FB Campaign Post Engagement],
8, [FB Campaign Frequency],
9, [FB Campaign 25% Played],
10, [FB Campaign 50% Played],
11, [FB Campaign 75% Played],
12, [FB Campaign 95% Played],
13, [FB Campaign 100% Played],
14, [FB Campaign 2s Continuous Plays],
15, [FB Campaign 3s Plays],
16, [FB Campaign ThruPlays],
17, [FB Campaign Video Plays],
18, [FB Campaign Leads],
19, [FB Campaign Post Comments],
20, [FB Campaign Post Reactions],
21, [FB Campaign Post Saves],
22, [FB Campaign Post Shares],
23, [FB Campaign Add To Wishlist],
24, [FB Campaign Adds to Cart],
25, [FB Campaign Purchases],
26, [FB Campaign Cost],
27, [FB Campaign Cost Per Click],
28, [FB Campaign Cost Per Lead],
29, [FB Campaign Cost Per Messages],
30, [FB Campaign Cost Per Purchase],
31, [FB Campaign Cost Per Reach],
32, [FB Campaign Cost Per Thousand]
)
Filter out =
IF(
SUMX(VALUES('PM For FB Campaign'[Type]),[FB Campaign Switch Measures]) = 0 , 1, 0)
as you see if i add the filter out as a card it shows 1 and 0 it works
if i add it to the second slicer it works
but when i add it to the "Type" Slicer, all values dissapear
can someone help me out
Solved! Go to Solution.
i made it work i just change the measure
FB Campaign Filter out =
IF(
SUMX(VALUES('PM For FB Campaign'[Order]),[FB Campaign Switch Measures]) = 0 , 1, 0)
i made it work i just change the measure
FB Campaign Filter out =
IF(
SUMX(VALUES('PM For FB Campaign'[Order]),[FB Campaign Switch Measures]) = 0 , 1, 0)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
11 | |
10 | |
10 | |
9 |
User | Count |
---|---|
18 | |
13 | |
12 | |
11 | |
8 |