Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I was wondering if in my scenario this is at all possible to accomplish.
What I would like to do is to create dynamic header names for my table visual that will change depending on the week number. The previous week column is a dynamic value, which i utilise in my report for filtering purposes as we only want to look into 5 weeks into the past.
Above is the final outcome I would like to achieve. As of now these header names are derived from the measure names and these will not change as we progress into the future weeks.
So for instance assuming we were in week 35 at present, week 4 would turn into week 34, week 3 into week 33 etc. and these header names would reflect that accordingly.
Hopefully it makes sense.
Thanks for your support in advance!
You can use a visual level filter using date column from your date table, and then use the filter type as relative then select past 5 weeks
Hi @Klaudiusz ,
From what I understood you need the columns to be dynamic right?
I just created the following measure and added it into the matrix column part:
Is this what you were looking for ?
I didnt get the previous week part. if that needs to taken in consideration could you please elaborate the requirement for me ?
I hope I was able to resolve your issue. If so please tag this as the answer to help others as well. 😊
Hi @Gayatri_D05 Let me elaborate on the topic.
I'm only interested in displaying 5 weeks prior to the present time in one table visual hence why I have got the "Previous weeks" column which is made out of the following formula:
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |