Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello Community,
I have a dashboard that looks like below:
Brand | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
A | New | Reshaped | End | |||||
B | New | Reshaped | End | |||||
C | New | Reshaped | End | |||||
D | New | Reshaped | ||||||
E | New | Reshaped |
Each months, the dataset is updated and values changed, or values are added or new brands are added in the Brand column.
The problem: Each months, I need a solution that will show only new cells or cells that have changed in a separate dashboard.
For exemple, next month, the dashboard will look like below ( The new values or values that have changed compared to the previous dashboard are in red color)
Brand | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
A | New | Reshaped | End | |||||
B | New | Reshaped | Reshaped | |||||
C | New | Reshaped | Reshaped | |||||
D | New | Reshaped | End | |||||
E | New | Reshaped | End |
The solution should therefore looks like below:
Brand | 2023 | 2024 |
B | Reshaped | |
C | Reshaped | |
D | End | |
E | End |
- Is there a way to build this solution without having to make an extraction each month and compare these two extractions?
- if not, what would be the function to compare 2 datasets or 2 dashboard and only return what has changed/new?
NB: The source file looks like the dashboard, as a pivot table. The excel file has been pivoted in the backend of my Power BI.
Thanks for the help
Thanks @some_bih I actually found a way to do it now : merge two tables, add conditional column based on the values form the two tables and filter the conditional column when values are different.
Hi @cris007 one of the alternatives is to create dynamic filter based on range.
Check links for example and details. I hope this help.
https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.