The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I hope I can explain as clearly as possible.
I have a table with status changes of cars.
The machine can have 3 statuses: 0 (done), 1 (in work) or 2 (new)
Status change writes per datetime
So, I create measure how much cars have status 1 (and required categories) on and before selected date and time
For example i choose 02.06.2023 and time 4.00 am
so from table i get 68 cars started work before and on this time
my measures
But now i need to show on chart how much cars started work on start day (from 1am because i show cars before to hour) and to end of day
it should be measure per selected date from slicer (not depend from time slicer) and chart should look like that
And today it should be values only to the active hour
but for another day from slicer, it should be all day on chart
I've been thinking about this for 2 weeks now and every time my measure is incorrectly displayed on the graph
Does your calendar table have the required hour level granularity?
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
18 | |
18 | |
16 | |
14 | |
12 |
User | Count |
---|---|
36 | |
35 | |
20 | |
18 | |
18 |