Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ColinRE
Helper I
Helper I

For Sliced Filtered Date, Plot all the Event Data

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:

ColinRE_0-1739220591634.png

 

 


The Data:

 

event_id model_name group_name variable value Date

1AAA1160July 8, 2024
1AAA1130July 9, 2024
1AAA1120July 10, 2024
2AAA190July 11, 2024
2AAA180July 12, 2024
2AAA175July 13, 2024
3AAA160July 14, 2024
3AAA130July 15, 2024
3AAA120July 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).

ColinRE_1-1739220620037.png

 

 

 

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

2 ACCEPTED SOLUTIONS
ColinRE
Helper I
Helper I

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? 

ColinRE_0-1739229780386.png

 

View solution in original post

Anonymous
Not applicable

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. 

vcgaomsft_0-1739242155106.png


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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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. 

vcgaomsft_0-1739242155106.png


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

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
Helper I
Helper I

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? 

ColinRE_0-1739229780386.png

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.