Using user input to select columns for column datetime difference calculations and visualisation

[Anonymous]

Hi there

I'm currently working with some data where each row represents a unit ID and the rest of the columns (around 10 of them) are datetime columns. Each of these datetime columns represent a timestamp at a specific point in a process flow.  I would love to have the end-user being able to choose two of these 10 columns (could be from slicers) and then get the visualisations filtered based on the timedifference between these two datetime columns that the user has selected.

I know I could create calculated difference columns for each n(n-1)/2 combinations and make a tab with visualisations for each of the combinations but I would just think there would be a better way so that it could all be done in one tab with only the column filters. There might also be some way to transform the data to fit my needs but I simply can't find any way which doesn't require me to create a ton of measures and/or calculated columns.

I hope I'm clear enough in my explanation, and thanks in advance for the help!

[amitchandak]

@Anonymous , if this just filter not the axis. You can follow the measure slicer approach. Create a table with 10 date time names (use as Date name slicer) . Have an independent date table for the date slicer.

Now based on date selection and date range in slicer create a measure

refer

https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern