Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi, I have a question relating to filters. How can I setup a filter that when you select time value it will also select all the previous values in the table?
Here is a sample data table..
Is there a way to achieve this with a measure or a filter setting?
Many thanks!
Solved! Go to Solution.
Hi @HRawash1
you may create a disconnected time table that will be used in the slicer
TimeTable =
SELECTCOLUMNS (
GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 45, 0 ), TIME ( 0, 15, 0 ) ),
"Time", [Value]
)
then place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter
FilterMeasure =
COUNTROWS ( FILTER ( 'Table', 'Table'[Intervsks] <= MAX ( TimeTable[Time] ) ) )
thank you so much solved
Hi @HRawash1
you may create a disconnected time table that will be used in the slicer
TimeTable =
SELECTCOLUMNS (
GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 45, 0 ), TIME ( 0, 15, 0 ) ),
"Time", [Value]
)
then place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter
FilterMeasure =
COUNTROWS ( FILTER ( 'Table', 'Table'[Intervsks] <= MAX ( TimeTable[Time] ) ) )
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!