cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chalapathy
Frequent Visitor

Different time slicers on the same table

I have an order table that has dimensions customer name, product type, specifications, finished date, finished weight, open weight and corresponding promise date.

I have slicers on customer name, product type, specifications. I also have time slicers one for finished date and one for promised date.

On a  table visual table, I would like to  show customer name, product type, specification, finished weight , open weight for the month(s) selected from finished date slicer and also for the open orders based for the month(s) selected from promised date slicer.

These will be based on the customer name and/or product type and/or specification slicers.

Any suggestions?

1 REPLY 1
v-jayw-msft
Community Support
Community Support

hi @chalapathy ,

Please check following steps as below:

1.Measure =

   VAR s_date =

       SELECTEDVALUE ( 'date'[dat], BLANK () )

   RETURN

          IF (

            NOT ( ISFILTERED ( 'date'[dat] ) ),

             0,

             IF (

               MAX ( 'order'[f_date] ) = s_date,

               1,

               IF ( MAX ( 'order'[p_date] ) = s_date, 1, BLANK () )

             )

          )

2.Filter measure is not blank on visual:

1.PNG

3.Result would be shown as below:

2.PNG

PBIX as attached, hopefully works for you.

 

Best Regards

 

Community Support Team _ Jay Wang

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors