The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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]
)
User | Count |
---|---|
70 | |
64 | |
62 | |
48 | |
28 |
User | Count |
---|---|
113 | |
80 | |
64 | |
55 | |
43 |