Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rahul_SC
Helper III
Helper III

Dynamically changing fields in table

Hi all,

 

How can I make this table dynamic in power BI. In next week, when the source data is updated with a new week (week 23) then this table should automatically gets refreshed like (week 18 should be removed and week 23 should be added in the feild) 

 

 

Rahul_SC_1-1654964701434.png

 

 

 

3 ACCEPTED SOLUTIONS
krohitrao
Regular Visitor

Hello,

Assumption: The weeks will be displayed only for a selected year. (i.e. the weeks are all from the same year and not from 2 different years).

You can follow the below steps and achieve the requirement:
1. Create a duplicate column of the Week Name. [ex: "Week 18 (2-8 May)" ]
2. Split the text with space delimiter and retain the column which gives the week number only. (i.e. 18, 19, 20 etc.)
3. Create a measure finding maximum of the week number.

MaxWeek = Calculate(MAX('Table'[Week Number]), ALL())
4. Create a calculated column which gives difference of MaxWeek with the week number.
Diff = [MaxWeek] - 'Table'[Week Number]
5. Now in the matric visual, add a filter for Diff -> Advanced filtering -> is less than 4

This will always show the top 4 weeks only. 
If weeks need to be taken irrespective of the year, then the logic for finding max week will change all others remain same.

View solution in original post

thanks for the link, it worked.

View solution in original post

@Rahul_SC 
Would you please consider marking my reply as acceptable soltion? Thank you

View solution in original post

5 REPLIES 5
Rahul_SC
Helper III
Helper III

@tamerj1 , Hi, sorry, I thought I had accepted it as a solution.

krohitrao
Regular Visitor

Hello,

Assumption: The weeks will be displayed only for a selected year. (i.e. the weeks are all from the same year and not from 2 different years).

You can follow the below steps and achieve the requirement:
1. Create a duplicate column of the Week Name. [ex: "Week 18 (2-8 May)" ]
2. Split the text with space delimiter and retain the column which gives the week number only. (i.e. 18, 19, 20 etc.)
3. Create a measure finding maximum of the week number.

MaxWeek = Calculate(MAX('Table'[Week Number]), ALL())
4. Create a calculated column which gives difference of MaxWeek with the week number.
Diff = [MaxWeek] - 'Table'[Week Number]
5. Now in the matric visual, add a filter for Diff -> Advanced filtering -> is less than 4

This will always show the top 4 weeks only. 
If weeks need to be taken irrespective of the year, then the logic for finding max week will change all others remain same.
tamerj1
Super User
Super User

Hi @Rahul_SC 

please follow the instructions in this video. You just need to change the 6 months period with 6 weeks period 

https://youtu.be/d8Rm7dwM6gc

thanks for the link, it worked.

@Rahul_SC 
Would you please consider marking my reply as acceptable soltion? Thank you

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.