I have this data: Where I have found workaround but need permanant solution.
I have used pivot table function to get below table: After pivot I have manually selected all dates as my columns.
This is expected output.
But when I refresh data next day, dashboard will be broken, since I am manually selecting days to display last 4 days of data in Power BI.
Can you help me achieve this without manually adding dates everyday?
Thank you in advance.
>> But when I refresh data next day, dashboard will be broken, since I am manually selecting days to display last 4 days of data in Power BI.
Would you please clarify how the dashboard is broken after refreshing?
Best Regards,Qiuyun Yu
Hi @v-qiuyu-msft , Please see below explanation. Thank you for your help with this issue.
Step 1: Pull last 5 days of data from Oracle db
Screenshot: Original data.Original data from last 5 days (Oracle db)
Step 2: Pivot data with column as date now
Using Transform - Pivot column function
Step 3: Dashboard with pivot table
Expected dashboard - 24th April (Dashboard Creation date)
Step 4: Dashboard is broken, due to 20th April column missing in the dashboard (since it pulls last 5 days of data)
Broken dashboard, 25th April not selected for dashboard
Is there a way I can get last 5 days of data with Date as column without manual intervention?
End goal: Email this dashboard as status update to eveyone in my team daily with last 5 days of data. (Dashboard same as expected dashboard screenshot - step 3)
I would suggest you delete the Pivoted Column step in Query Editor, then apply the change. Go to Report tab, add a matrix visual, put the CREATE_DATE column in the Columns bucket. In Visual Level Filter, set a filter condition like below:
Hi @v-qiuyu-msft ,
Thank you so much for your help with my dashboard.
I tried this Matrix table and everything is working fine. except one condition when I am trying to add a column from other source. I can merge the data, but I am not able to see any null data THOUGH I have selected "Show items with no data"
Data without NULL
Can you help me get NULL data as well?
Appreciate your help.
I was able to see NULL values earlier with same tables with the pivot function and TABLE graph.
It's hard to provide further help without looking into the issue on your side. I would suggest you create a support ticket to get dedicated support.