The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I've linked my dashboard with excel sources and i designed the whole dashboard, but i'm just missing the main request that i received from my managament.
We need this dashboard to compare or old data (before clicking refresh button) with or new data ( after clicking refresh button) to tells which area has new changes and what's the difference exactly?
for example : i have a bar chart with 20 patents for march and when i refresh on april i had 18 patents only, i want to know exactly what happend in the last month's patents'. which department withdrew thier patent?
i hope it's clear enough 😣😣😣😣.
Power BI has no memory, and no concept of global variables. You need to do that snapshotting in the upstream system.