Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi - I am wanting to have column headings that change as my dashboard is refreshed or updated.
For example, I'd like the below "current week" heading to say "Jan 14-20" as the values in that column are calculated for that date range. Is there a way to do this?
Thank you,
Solved! Go to Solution.
I initially implemented this as a DAX calculated column but then realized this would not work as it doesn't sort the result correctly. I reverted back to the standard method of supplying an external calendar table instead. See attached for both options.
If by "dynamic" you mean "recalculated during every import mode dataset refresh" then yes. Otherwise please provide more details, some sample data would be nice too.
Essentially, I'd like to see week over week # of Hired Employees. The weeks runFriday-Thursday, though.
For example, if my raw data looks like something like this:
Hires | Region | Effective Date of Hire | Dashboard Refresh Date |
1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
1 | Consumer Ret | 1/20/2022 | 1/31/2022 |
1 | Consumer Ret | 1/21/2022 | 1/31/2022 |
1 | Consumer Ret | 1/21/2022 | 1/31/2022 |
1 | Consumer Ret | 1/27/2022 | 1/31/2022 |
And I'd like it summarized like this
Hires | |||
Region | Jan 14-20 | Jan 21-27 | YTD |
Consumer Ret | 6 | 3 | 9 |
What would be the expected column header for the next week? "Jan 28-Feb 3" ? You may be running out of screen real estate fast.
Hi,
Yes, next column would be Jan 28-Feb 3. I am only planning to show the last 4 weeks.
PLease add some more sample data so it covers that whole period.
Let me know if you need any additional data.
Thank you!!
Raw Data:
Hires | Region | Effective Date of Hire |
1 | Consumer Ret | 1/14/2022 |
1 | Consumer Ret | 1/14/2022 |
1 | Consumer Ret | 1/14/2022 |
1 | Consumer Ret | 1/14/2022 |
1 | Consumer Ret | 1/14/2022 |
1 | Consumer Ret | 1/20/2022 |
1 | Consumer Ret | 1/21/2022 |
1 | Consumer Ret | 1/21/2022 |
1 | Consumer Ret | 1/27/2022 |
1 | Consumer Ret | 1/28/2022 |
1 | Consumer Ret | 1/28/2022 |
1 | Consumer Ret | 2/3/2022 |
1 | Consumer Ret | 2/3/2022 |
1 | Consumer Ret | 2/3/2022 |
1 | Consumer Ret | 2/4/2022 |
1 | Consumer Ret | 2/4/2022 |
1 | Consumer Ret | 2/10/2022 |
1 | Consumer Ret | 2/10/2022 |
Week Over Week - What I'd Like to Get to
Region | Jan 14-20 | Jan 21-27 | Jan 28-Feb 3 | Feb 4 - Feb 10 | YTD |
Consumer Ret | 6 | 3 | 5 | 4 | 18 |
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |