The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
How can I change my 24"day" to be from 4:30AM - 4:29AM. (So not, 12:00AM - 12:00AM)
My Date/Time column is : "Date and Time"
Column/ Measure preffered please.
In this example, I am calculating the mileage on one given day. However, Power BI is picking up the day from 12:00AM to 12:00AM.
Our day starts at 4:30AM and ends at 4:29AM the next day. I'd like the slicer to calclaute 1 day as 4:30AM- 4:29AM.
But how does your data look like and from which table/column does the date slicer come ftom?
Date Slicer is from Table: Bus Notification & Mileage: Date and Time
here is the rest of the breakdown
hi @amandabus21
try to make a screenshot of the data table containing the relevant columns
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |