Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
cris007
Frequent Visitor

Only show new cells or changes made in cells after update

Hello Community, 



I have a dashboard that looks like below:

 

Brand20172018201920202021202220232024
ANew Reshaped End   
B New Reshaped  End 
CNew   Reshaped  End
D New   Reshaped  
E    NewReshaped  



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)

 

Brand20172018201920202021202220232024
ANew Reshaped End   
B New Reshaped  Reshaped 
CNew   Reshaped  Reshaped
D New   ReshapedEnd 
E    NewReshaped End

 

The solution should therefore looks like below: 

Brand20232024
BReshaped 
C Reshaped
DEnd 
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

2 REPLIES 2
cris007
Frequent Visitor

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. 

some_bih
Super User
Super User

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 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors