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 have a measure f(x) and need to create a line graph. let's say f(0)=0, f(1)=1, f(2)=2, f(3)=2.2, f(4)=2.5, f(5)=2.7, f(6)=3, f(7)=3, f(8)=3...f(21)=3. My end users wants to stop graph at a point when f(x) doesn't change it value. In my example I should show only f(0), f(1)..f(6). They don't want to see f(7) on a graph at all. Is it possible?If possible, how can I modify my function?Thanks a lot in advance!
Solved! Go to Solution.
@Anonymous
You may add a new measure and take a look at Show items with no data.
Measure 2 =
VAR k =
SELECTEDVALUE ( 'Table'[x] )
RETURN
IF (
[Measure]
<> CALCULATE (
[Measure],
TOPN (
1,
FILTER ( ALLSELECTED ( 'Table'[x] ), 'Table'[x] < k ),
'Table'[x], DESC
)
),
[Measure]
)
@Anonymous
You may add a new measure and take a look at Show items with no data.
Measure 2 =
VAR k =
SELECTEDVALUE ( 'Table'[x] )
RETURN
IF (
[Measure]
<> CALCULATE (
[Measure],
TOPN (
1,
FILTER ( ALLSELECTED ( 'Table'[x] ), 'Table'[x] < k ),
'Table'[x], DESC
)
),
[Measure]
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
99 | |
68 | |
44 | |
38 | |
30 |
User | Count |
---|---|
157 | |
90 | |
62 | |
46 | |
40 |