Forum Discussion
Solved
Create custom text based date on X axis
Hi BI folks, Im looking our for a ideal / best approaches to handle below type of visual requirement in purely Power BI or SQL code. How to build the data view for this? In the mockup i...
since we don't have the fact table, i can only create the date table for testing.
pls see the attachment below
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