Forum Discussion
Replace a table value with another based on a specific date (when refreshing or publishing)
Hi Stathis,
First, you can't replace existing table records in dataview level, you need to go to query editor or change them on datasource side.
I'd like to suggest you to take a look at following link about dynamic attribute based on slicer, it should suitable for your requirement.
Dynamic Attributes In A Power BI Report
Regards,
Xiaoxin Sheng
Anonymous
Xiaoxin Sheng,
Thank's a lot for your reply. It really helped me understand Dynamic Attributes based on a slicer.
I tried to add to the dynamic slicers time intervals (day-week-month) and in this way to combine 3 different reports (daily-weekly-monthly) into one (this is my purpose).
This method, includes the creation of a table with static time intervals day,week,month (month=30 days), and I have the above limitations:
1) Changing the output of a visual: I would like to automatically demonstrate 2 basic metrics in my daily report, 3 metrics (the 2 basics plus 1 new) in my weekly report, and 4 metrics in monthly report. The purpose here is the columns of my visualization (matrix) to be adjusted by the choice of the slicer.
2) If I set up dynamic time slicers (for example month) the time interval is inaccurate in most cases (closing months are 28-31 days so the selection of 30 days is inaccurate).
Any extra help will be much appreciated!
Best Regards,
Stathis
Hi Stathis,
#1. I'm not so clearly for this requirement, can you please explain more detail?
#2. You can try to use date function to manually define dynamic month range.For example:
Replace Column = VAR currDate = xxx //specific date RETURN CALENDAR ( DATE ( YEAR ( currDate ), MONTH ( currDate ), 1 ), DATE ( YEAR ( currDate ), MONTH ( currDate ) + 1, 1 ) - 1 )Above formula will dynamic get accurate month range based on inputted date dynamic.
Regards,
Xiaoxin Sheng