For Sliced Filtered Date, Plot all the Event Data

[ColinRE]

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])​

[ColinRE · Accepted solution]

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? 

[v-cgao-msft · Accepted solution]

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

[ColinRE]

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. 

[ColinRE · Accepted solution]

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?