March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
167 | |
117 | |
63 | |
57 | |
50 |