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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jr3151006
Helper IV
Helper IV

Date Slicer - is there a way to save its value as a PARAMETER and then use it as table filter?

Hi,

 

I was wondering if it's possible catch slice selected dates and then save it to a VARIABLE/PARAMETER which will be used to filter a DATE field in a table.

 

Can I do that?

4 REPLIES 4
v-luwang-msft
Community Support
Community Support

Hi @jr3151006 ,

Slicer works on visual level, it will not filter the underlying data. You could create a query parameter and use it to filter data when you loading data.

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters 

 

 

 

Similar question refer:

https://community.powerbi.com/t5/Desktop/power-bi-pass-slicer-value-as-query-parameter/td-p/2189511 

 

 

Best Regards

Lucien

🙄👌

Hi @jr3151006 ,

I'm sorry if I misunderstood your intentions at first, but you can check if this sample below is what you are looking for.
Base data.

vluwangmsft_0-1669888510536.png

 


When the slicer selects 1, the type car corresponding to 1 is passed to the filter, which then filters out all data whose type is car.

vluwangmsft_1-1669888541094.png

Solution:

create a slicer table:

vluwangmsft_2-1669888586140.png

 

Then use the below measure:

Measure = 
VAR selectedids = VALUES('ID For Slicer'[ID])
VAR myType=CALCULATETABLE(VALUES(Table1[Type]),Filter(all(Table1),Table1[ID] in selectedids))
RETURN
if(VALUES(Table1[Type]) in myType,"Yes","N0")

 

Apply to filter:

vluwangmsft_3-1669888637218.png

 

 

 

Best Regards

Lucien

Greg_Deckler
Super User
Super User

@jr3151006 You can do it inside a measure but unfortunately a measure cannot return a non-scalar value. So your measure would have to be something like:

Measure = 
  VAR __Dates = 'Dates'[Date]
  <do some stuff>
RETURN
  <something>

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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