Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |