topic For Sliced Filtered Date, Plot all the Event Data in DAX Commands and Tips

For Sliced Filtered Date, Plot all the Event Data

ColinRE — Mon, 10 Feb 2025 22:48:04 GMT

Hey Folks,

Been struggling with this seemingly simple problem: for a sliced Date Time, get the event and plot all the associated values.

Click here for PBI File

What I want:

The Data:

event_id model_name group_name variable value Date

1	A	A	A1	160	July 8, 2024
1	A	A	A1	130	July 9, 2024
1	A	A	A1	120	July 10, 2024
2	A	A	A1	90	July 11, 2024
2	A	A	A1	80	July 12, 2024
2	A	A	A1	75	July 13, 2024
3	A	A	A1	60	July 14, 2024
3	A	A	A1	30	July 15, 2024
3	A	A	A1	20	July 16, 2024

What I tried (2 different measures noted below). Both result in 1 plot point. I can't seem to be able to ignore the date slicer. There is only 1 table (for now).

Variation 2

Y value 2 =
VAR getEvent = MAX('Model'[event_id])
VAR getResult =
CALCULATE( MAX('Model'[value]),
'Model'[event_id] = getEvent,
REMOVEFILTERS('Model'[event_id])
)
RETURN getResult

Variation 3:
Y value 3 =

VAR getEvent =

MAX('Model'[event_id])

VAR getFilterTable =

CALCULATETABLE(

SELECTCOLUMNS('Model',
"Dates", 'Model'[Date],
"Yplot", 'Model'[value] ),
REMOVEFILTERS('Model'[Date]),
'Model'[event_id] = getEvent )
RETURN

MAXX(getFilterTable,[Yplot])

Re: For Sliced Filtered Date, Plot all the Event Data

ColinRE — Tue, 11 Feb 2025 00:21:13 GMT

I just tried this: https://community.fabric.microsoft.com/t5/Desktop/DATA-Slice-Interaction/m-p/3724209

And I was able to get the result I wanted but, curious, is there a way to do it without a visual level measure? Is this a hack or acceptabe solution?

Re: For Sliced Filtered Date, Plot all the Event Data

Anonymous — Tue, 11 Feb 2025 03:02:33 GMT

Hi ColinRE ,

As you discovered, you need to create a separate unconnected table for the date slicer to ensure that the 'model'[date] column filter does not affect the Model table.

Editing interactions, using mediators like ALL, REMOVEFILTERS, etc. in the same table cannot do this.

'Model'[event_id] actually contains filters derived from 'Model'[Date] as well, and they interact with each other (from same table), you can't keep filters from just one of them.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: For Sliced Filtered Date, Plot all the Event Data

ColinRE — Tue, 11 Feb 2025 16:24:54 GMT

Thank you Gao for taking the time to explain it. Just when you think you are decent at PBI, there's always one more thing that stumps you.