Forum Discussion

vissvess's avatar
vissvess
Icon for Helper V rankHelper V
7 years ago

Slicer selection for bins

Hi,   My scenario is as follows.   I have created bins/groups with 1 hour bucket sizer for time column, which have different time stamps of all processes in a category.   A column chart was cre...
Dax Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hiya.

 

At this very moment it's not entirely clear to me what you want. Would you please enlarge a bit upon it? Some pics would certainly help. I need to see your model and some rough visualization(s) of what it is you need.

 

Thanks.

 

Best

Darek

  • vissvess's avatar
    vissvess
    Icon for Helper V rankHelper V
    7 years ago

     

    Anonymous ,This is the snapshot of the visualisation. This contains time being converted to bins with bucket size of 1 hour which you can see. I want the report user to change the bin bucket size to see the values.

     

    Hope Its clear now and expecting valuable help. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi there.

       

      Mate, please contemplate this:

       

      The x-axis changes accordingly to which time bucket you select:

       

      This is what you wanted, right?

       

      Here's a file that shows you how to achieve it.

       

      Best

      Darek

      • vissvess's avatar
        vissvess
        Icon for Helper V rankHelper V
        7 years ago

         

        Dear Anonymous ,

         

        Thanks for getting back with a valuable solution. Happy to hear from you.

         

        The solution is great but my data set is different. I am not able to unpivot my data with as many with 5 new columns representing bucket sizes as the data is huge.

         

        Lemme elaborate.

        The snapshot I shared was created using New group--> bins. See below.

         

         

         

         

         

         

         

         

         

         

         

        Here the bin size entry is not dynamic. I was looing around a way to make it dynamic based on selection.

        But the above steps gives me a calculated column (Time(Bins)) in my modelling tab as follows.

        Based on above 3 Hour selection, a column based on time column is created stating which bucket it falls on.

         

         

         

         

         

        I thought of automating that in another way based slicer selection.

        --> So, I have created a isolated table with single column containing 1hr/2hr/3hr/4hr/8hr.

        --> A slicer for the column

        -->Then I am now looking for an expression which if one of the 1hr/2hr/3hr/4hr/8hr is selected, based on the value the calculated column to be calculated.

         

        Does this way help be solve the scenario.? Could anyone help with the expression.?

         

        Thanks