Data Visualization

[FARSANA97]

I need to get difference between harvest date and the date selected in date slicer and classify them into 1-30 days, 31-60 days, and more than 60 days and bring that as columns as in the format I have given. I am able to find difference between date selected in the date slicer and harvest date by introducing measure, but since measure can't be taken as columns or axis in graph I am not satisfying my requirement, How can I achieve it?

[amitchandak]

@FARSANA97 ,

Try following measures assuming you already have a measure Value Measure

Datediff = datediff(max(Table[Harvest date]), selectedvalue(date[Date]), day)

0-30 days= sumx(Values(Table[Harvest date]), if([Datediff] <=30 , [Value Measure], blank() ) )

31-60 days= sumx(Values(Table[Harvest date]), if([Datediff] >30  && [Datediff]  <= 60, [Value Measure], blank() ) )

If not you can do dynamic Segmentation on datediff

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k