Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
How do i get a line graph to show the first n number of days rather than actually a date range
Please can someone help me out,
Thanks
Kunal
Solved! Go to Solution.
@kdaya wrote:
Hi
How do i get a line graph to show the first n number of days rather than actually a date range
Please can someone help me out,
Thanks
Kunal
A measure as below for your reference, the measure varies according to the N days in a slicer. See more details in the attached pbix file.
First N Days value = SUMX ( FILTER ( ALL ( 'values' ), 'values'[date] <= MAX ( 'values'[date] ) && 'values'[date] >= MAX ( 'values'[date] ) - MAX ( 'First N Days'[N] ) ), 'values'[values] )
@kdaya wrote:
Hi
How do i get a line graph to show the first n number of days rather than actually a date range
Please can someone help me out,
Thanks
Kunal
A measure as below for your reference, the measure varies according to the N days in a slicer. See more details in the attached pbix file.
First N Days value = SUMX ( FILTER ( ALL ( 'values' ), 'values'[date] <= MAX ( 'values'[date] ) && 'values'[date] >= MAX ( 'values'[date] ) - MAX ( 'First N Days'[N] ) ), 'values'[values] )
You can apply a visual filter.
Click on the line chart -> Go to filter section under your visuals -> Change the Filter Type to Top N -> Drag your date column to By Value and enter the number of day you want to see.
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |