Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating a dynamic table

Hi everyone, is it possible to create a dynamic table that returns the unique values from a column based on selected slicer. I want to sprint a report to shows daily task count in a a sprint. the num...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    Create a measure like this and apply it to visual level filter.

    Measure = SWITCH(TRUE(),
MAX('Table'[Sprint])="Sprint 10"&&MAX('Table'[Sprint Day])<=3,1,
MAX('Table'[Sprint])="Sprint 11"&&MAX('Table'[Sprint Day])<=2,1,0)

     

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

camargos88's avatar
camargos88
Community Champion
5 years ago

Hi Anonymous ,

 

Tables are created when the refresh happens. 

You can create measures and filter the data to show only the values based on the user selection.

 

Show us some data example and we can work on it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Below is a sample data.

     

    I want to the table to show Days: 1,2,3 when I select Sprint 10 and just 1,2 when I select Sprint 11

     

    Sprint DaySprintTasksAssignedHours
    1Sprint 10Task 1User A2
    1Sprint 10Task 2User A1
    2Sprint 10Task 1User B2
    3Sprint 10Task 3User C1
    1Sprint 11Task 1User C2
    2Sprint 11Task 5User A1
    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      5 years ago

      Anonymous 

      Create slicer using the table[Sprint] field (or create a dimension/lookup table with unique table[sprint] vales and join via a relationship to your fact table via the common field) and a table as you have shown. When you select a value(s) in the slicer, the table will be filtered accordingly. 

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

        Create a measure like this and apply it to visual level filter.

        Measure = SWITCH(TRUE(),
MAX('Table'[Sprint])="Sprint 10"&&MAX('Table'[Sprint Day])<=3,1,
MAX('Table'[Sprint])="Sprint 11"&&MAX('Table'[Sprint Day])<=2,1,0)

         

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