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
Anonymous
Not applicable

Bypass Keep All Filters on Drillthrough

Can someone help please. 

 

When I drillthrough with a Measure the 'Keep all filters' automatically comes on. 

 

It is the reason the Janruary data is showing and I need to somehow bypass this. 

 

The expected result is so see the top 3 values only 

 

Does anyone know how I can do this?

 

PBIStudy123_0-1641567639333.png

 

Measure data is below - 

 

Example1 =
SWITCH(
TRUE(),
'New - Timesheet 2021'[Hours2] >=0 && 'New - Timesheet 2021'[Hours2] <=15, 0,
'New - Timesheet 2021'[Hours2] >=16 && 'New - Timesheet 2021'[Hours2] <=30, 0.5,
'New - Timesheet 2021'[Hours2] >=31 && 'New - Timesheet 2021'[Hours2] <=60, 1
)

 

1 ACCEPTED SOLUTION

Hi, @Anonymous 

 

You can refer to the following methods. Your formula is fine no need to change it.

vzhangti_0-1641885305529.png

Put Example1 in Filters, set to not equal to 0.

vzhangti_1-1641885358275.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @amitchandak thanks for your response. so is there a way I can convert my measure into a column so I can use that in a bar graph? 

 

thanks 

Hi, @Anonymous 

 

You can refer to the following methods. Your formula is fine no need to change it.

vzhangti_0-1641885305529.png

Put Example1 in Filters, set to not equal to 0.

vzhangti_1-1641885358275.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , I drill through we can pass only value from one row, not more than that.

 

Keeping all filters means all filters will pass. And you switch it off. Whatever is below that will be passed

 

Measure will not pass any filter information. Measure in drill down page can control

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.