Forum Discussion
Create custom text based date on X axis
since we don't have the fact table, i can only create the date table for testing.
pls see the attachment below
do you have a date slicer that will change the date or if the data were updated, this visual always display last 2 weeks data？
what's more, could you pls provide some sample data? how we get the base case value?
hi Ryan,
- Always display last 2 weeks (sun-sat) dynamically (looking into it today- it will be 30 mar - 5 mar (Previous week)& 6 - 12 mar (last week)). Current week will not be included because its has not completed the full 7 days timeframe.
- for base case, we can enter sample data using datatable in power bi (kpi name & base value) as its a constant value.
thanks in advance!
since we don't have the fact table, i can only create the date table for testing.
pls see the attachment below