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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
WTAS80486
Helper IV
Helper IV

Ignore a slicer but consider another on the same page

I have a table called Order, with columns Order, Reported date, Finish Date etc.I want to create a dax mesure to calculate Total no of workorders in that table such that the measure when pulled in a visual to show total orders should change with Reported date slicer but it should not affected by a Finish Date slicer on the same page.

 

For example slicer on Finish date shows date from 1/29/2024 to 1/31/2024 and total orders created as 103 which is actually for any reported date on or after 1/29/2024, now when date on slicer for Finish Date is chnaged to 1/30/2024-1/31/2024 it should still show 103 and same 103 for finish date 1/29/2024 to 1/31/2024

 

I need to have another measure in the same visual which calculates orders which are closed and completed and this measure should be affected by Finish date slicer and not the reported date slicer

7 REPLIES 7
v-kongfanf-msft
Community Support
Community Support

Hi @WTAS80486 ,

 

Based on your description, you can try to implement this using the edit interactions feature: create separate report date and finish date date slicers and let them filter the specified visual.

vkongfanfmsft_0-1706856847574.png

 

For more details, you can read below document:

Change how visuals interact in a report - Power BI | Microsoft Learn

 

Best Regards,
Adamk Kong

 

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

I need to use finish date and reported date from the same table. calculate total orders so that it is not affected by finish date slicer but is affected by reported date. just the reverse for another measure to calculate completed orders(order status =COMP) . should change with finish date slicer  but not with reported date. both these measures have to be used in a column chart to show total orders and completed orders

Hi @WTAS80486 ,

 

You can try formula like below:

TotalOrders =
CALCULATE ( COUNTROWS ( Orders ), ALL ( 'Orders'[FinishDate] ) )
CompletedOrders =
CALCULATE (
    COUNTROWS ( Orders ),
    'Orders'[OrderStatus] = "COMP",
    ALL ( 'Orders'[ReportedDate] )
)

 

Best Regards,
Adamk Kong

 

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

My issue is I have to use two measures in the same visual and the first measure should not be affected by finish date but the second one should be affected by finish date so I cannot disconncet the visual from slicer.same for reported date, first ne should be affected by reported date and 2nd measure should not be affected.

.

amitchandak
Super User
Super User

@WTAS80486 , Create an independent/Disconnected table and use that filter finish date , close or completed date as per need

I need to use finish date and reported date from the same table. calculate total orders so that it is not affected by finish date slicer but is affected by reported date. just the reverse for another measure to calculate completed orders(order status =COMP) . should change with finish date slicer  but not with reported date. both these measures have to be used in a column chart to show total orders and completed orders

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.