topic Re: selection d'une heure dans un segment mais dans le diagramme et/ou tableau doivent avoir plus de lig in DAX Commands and Tips

selection d'une heure dans un segment mais dans le diagramme et/ou tableau doivent avoir plus de lig

Anonymous — Thu, 27 Jan 2022 19:54:28 GMT

Bonjour

J’ai un tableau et un diagramme.

lorsque je choisis une date dans un segment A, il m’affiche le numero de voitures qui parcours plus sieurs trajets exemple

Voiture VOIE heure Nb mchdises

Voit 1 Voie 0 2/01/2022/7H00:00 22

voit 1 Voie 1 2/01/2022 7H33:00 21

voit 1 Voie 2 01/02/2022 7H45:00 13

voit 1 VOIE 44 01/02/2022 17H22:00 1

j’ai un autre segment B, qui est l’heure si je choisis 7H33 il me propose une ligne trajet 2 Voie 1 2/01/2022 7H33:00

Je ne veux pas une ligne, je veux le trajet allant de la voie 1 à la voie 44 et la voiture qui convient une fois j’ai choisi la date dans le segment A et l’heure dans le segment B Comment faire?

Merci en attendant vos réponses.

Re: selection d'une heure dans un segment mais dans le diagramme et/ou tableau doivent avoir plus de lig

Anonymous — Fri, 28 Jan 2022 09:30:56 GMT

I put in english also the subject.

I have two segments. A segment A who allow me to choose a date and a segment b who allow me to choose an hour minute. I want when a user choose a hour on the segment B i WANT in diagramm or table that the table have more than a line but several ligne of this hour choosing where all voie appear. Exemple if I choose 7H33 I want to see more in the diagramm or table that the line of 7H33 even the user choose in segment B 7H33.

Re: selection d'une heure dans un segment mais dans le diagramme et/ou tableau doivent avoir plus de lig

v-jingzhang — Mon, 31 Jan 2022 09:00:41 GMT

Hi Anonymous

Can you provide some sample data and expected result both in table format to help us understand your requirement better? Do you mean that you want to have 2 slicers in the report, one is to filter the date and the other is to filter the time (hour&minute)?

In your current sample data, there are two dates and four time values. Do we need to filter a date then filter a time to find the lines whose datetime values are consistent with the selected values?

Best Regards,
Community Support Team _ Jing

Re: selection d'une heure dans un segment mais dans le diagramme et/ou tableau doivent avoir plus de lig

technolog — Wed, 15 Oct 2025 19:28:48 GMT

Build proper Date and Time tables
Create a Date table that covers all days in your data and mark it as a date table.
Create a Time table with one row per minute from 00:00 to 23:59. Add convenience columns like Hour, Minute, and a text label for the slicer such as 07:33.

Example DAX for the Time table

Time =
ADDCOLUMNS(
GENERATESERIES( TIME(0,0,0), TIME(23,59,0), TIME(0,1,0) ),
"Hour", HOUR([Value]),
"Minute", MINUTE([Value]),
"TimeText", FORMAT([Value], "HH:mm")
)

Prepare your fact table
Split your datetime into separate date and time columns.

DateOnly = DATEVALUE( Fact[DateTime] )

TimeOnly = TIME( HOUR(Fact[DateTime]), MINUTE(Fact[DateTime]), 0 )

Create a simple trip key. If you have at most one trip per car per day, this is enough

TripID = Fact[Car] & " " & FORMAT( Fact[DateOnly], "yyyymmdd" )

If you can have many trips per car in one day, define a business rule for what counts as a new trip, for example a long gap between records, and build a stronger TripID. The rest of the pattern stays the same.

Create relationships
Relate Date[Date] to Fact[DateOnly] with an active relationship.
Relate Time[Value] to Fact[TimeOnly] with an inactive relationship. The time slicer will use the Time table, and the filter from that slicer will be applied only inside measures where you explicitly activate the time relationship.
Create a measure that finds the trip for the selected minute
This measure says yes for rows that belong to any trip that has at least one record at the selected minute on the selected date.

Show Trip =
VAR TripsAtSelectedMinute =
CALCULATETABLE(
VALUES( Fact[TripID] ),
USERELATIONSHIP( Fact[TimeOnly], Time[Value] )
)
RETURN
IF( CONTAINSROW( TripsAtSelectedMinute, Fact[TripID] ), 1, 0 )

Build the visual and hook the filters
Put Voie, Car, DateOnly, TimeOnly, and any metrics you want into a table visual.
Add the Show Trip measure to the visual level filters and keep only value 1.
Use the Date table column in your date slicer.
Use the Time table column TimeText in your time slicer.