Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've created a streaming dataset in my Power BI Web environment. I need to show the live-data in a Dashboard.
Therefore I connected to the dataset in Power BI Desktop and I'm getting the data as expected:
The problem occurs, when I want to show the latest value (percentage) only:
Sometimes it does show me the latest value, but it quite often doesn't return a value at all (-> blank).
Similiar issues when I try to show N Top values only in a table: It doesn't return the requestet amount (e.g. I chose N=10, but getting back two values. After the next data push, I've got just 5 values listed....
I've tried to create a measure as well, but same problem:
Most Recent Max Rate =
VAR LatestTimestamp =
MAX(RealTimeData[timestamp])
VAR LatestMaxRate =
CALCULATE(
MAX(RealTimeData[percent]),
RealTimeData[timestamp]=LatestTimestamp
)
RETURN
LatestMaxRate
I suggest there might be a date formatting issue, but I've no idea how to solve it.
Does anyone have an idea what I'm doing wrong here?
Solved! Go to Solution.
@Macrosoft , try like
lastnonblankvalue( RealTimeData[timestamp], MAX(RealTimeData[percent]))
Hi @amitchandak
Thanks a lot for your help.
It worked perfectly! I still don't kown what caused the issue, but I'm glad it works now 🙌🏼.
Cheers
@Macrosoft , try like
lastnonblankvalue( RealTimeData[timestamp], MAX(RealTimeData[percent]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |