Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 number of days in a sprint differs and I want to create a new table that will show a list of sprint days for a selected sprint. Right now the table I created is select the disticnt of all the sprint days respective of the sprint
Solved! Go to Solution.
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.
@Anonymous , I dynamic table can not be created using slicer.
You can have a dynamic table inside a measure if needed
How do I achieve that
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 Day | Sprint | Tasks | Assigned | Hours |
1 | Sprint 10 | Task 1 | User A | 2 |
1 | Sprint 10 | Task 2 | User A | 1 |
2 | Sprint 10 | Task 1 | User B | 2 |
3 | Sprint 10 | Task 3 | User C | 1 |
1 | Sprint 11 | Task 1 | User C | 2 |
2 | Sprint 11 | Task 5 | User A | 1 |
@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.
Proud to be a Super User!
Paul on Linkedin.
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.
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |