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.
I’ve created the scatter chat below based on “SIZE” and “SCORE” metrics:
Size = CALCULATE(DIVIDE(SUM((table[Size_number])),COUNTROWS(table)))
Score = SUM(table[New_value])
Additionally, I create a parameter (slicer) through the option to considerer 4 measures (Big Bet, Incremental, Money Pit and Quick Win)
Parameter = {
("Big Bets", NAMEOF('Measure'[BB]), 0),
("Incremental", NAMEOF('Measure'[IN]), 1),
("Money Pit", NAMEOF('Measure'[MP]), 2),
("Quick Win", NAMEOF('Measure'[QW]), 3)
}
Measures:
BB = IF([Size]>3&&[Score]>72,"Big Bets","")
IN = IF([Size]<=3&&[Score]<=72,"Incremental","")
MP = IF([Size]>3&&[Score]<72,"Money Pit","")
QW = IF([Size]<=3&&[Score]>=72,"Quick Win","")
At the end, I want to filter the 'INITIATIVE' using a parameter as a slicer. However, I am not sure how to link the parameter to the graph. I believe there might be a missing link between them.
I appreciate any contribution to solve this issue.
Thanks
Those seem to be unrelated things. Your quadrants should always be present on the chart, so your filter would be more like a highlighter?
you are right. The quadrants will be always there, however, I want to present only those selected from the slicer.
Go with the highlighter, don't waste your time on the filter.
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 |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |