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...
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.

     

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.