Forum Discussion

chalapathy's avatar
chalapathy
Frequent Visitor
6 years ago

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?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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:

    3.Result would be shown as below:

    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.