Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Barchart

I created a calculated column to create the below groups which are split based on the diff in days between one day and today()

Below 7

Between 7 and 14

More than 14 

 

 

I was asked if it is possible to create a parameter that allows you to change the day diff you want to split the groups into. 

 

Regards,

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Please do like this.

    1. Create a "What If Parameter".

    2. Create such a measure.

    Expected Delivery - No subscribed = 
SWITCH(
    TRUE(),
    MAX([Delivered?]) = "Yes" && MAX([Subscribed?]) = "No", 10,
    MAX([Delivered?]) = "No" && MAX([Subscribed?]) = "No" && DATEDIFF(TODAY(), MAX([Expected Delivery Date]), DAY ) <= [Parameter Value], 5,
    MAX([Delivered?]) = "No" && MAX([Subscribed?]) = "No" && DATEDIFF(TODAY(), MAX([Expected Delivery Date]), DAY ) > [Parameter Value], 0
)

     

    Best regards,
    Lionel Chen

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

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , what do you mean by parameter here.

    If you need it dynamic based on a selected date, you need to create a measure and then use an independent bucket table and create a new measure with row context

     

    measure =
    var _max = maxx(allselected('Date'),'Date'[Date])
    return
    datediff(max(Table[Date]),_max, DAY)

     

    refer how to do dynamic segmentation https://www.youtube.com/watch?v=CuczXPj0N-k

     

    https://www.daxpatterns.com/dynamic-segmentation/
    https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Sorry if I don't explain myself correctly.

       

      I have created a calculated column that shows items that are going to expire within the following 7 days and more than 7 days.

       
      Expected Delivery - No subscribed = SWITCH(true(),
      'Sales Support'[Delivered?]="Yes" && 'Sales Support'[Subscribed?] = "No",10,
      'Sales Support'[Delivered?]="No" && 'Sales Support'[Subscribed?] = "No" && DATEDIFF(TODAY(),'Sales Support'[Expected Delivery Date],DAY)<=7,5,
      'Sales Support'[Delivered?]="No" && 'Sales Support'[Subscribed?] = "No" && DATEDIFF(TODAY(),'Sales Support'[Expected Delivery Date],DAY)>7,0)
       

      I was asked whether there is a way to make number 7 dynamic by a parameter or slicer that affects the previous chart.

       

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Please do like this.

    1. Create a "What If Parameter".

    2. Create such a measure.

    Expected Delivery - No subscribed = 
SWITCH(
    TRUE(),
    MAX([Delivered?]) = "Yes" && MAX([Subscribed?]) = "No", 10,
    MAX([Delivered?]) = "No" && MAX([Subscribed?]) = "No" && DATEDIFF(TODAY(), MAX([Expected Delivery Date]), DAY ) <= [Parameter Value], 5,
    MAX([Delivered?]) = "No" && MAX([Subscribed?]) = "No" && DATEDIFF(TODAY(), MAX([Expected Delivery Date]), DAY ) > [Parameter Value], 0
)

     

    Best regards,
    Lionel Chen

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