Forum Discussion
FarhanFahami_
2 years agoFrequent Visitor
Power BI Progress Update Comparison between 2 dates
Greeting guys! I'm currently stuck on building a visual matrix in PowerBI. My expected output should display the project details that show the progress based on the latest date compared to their ...
- 2 years ago
lbendlin
2 years agoSuper User
Use a measure as a visual filter to suppress rows where the value is the same.
FarhanFahami_
2 years agoFrequent Visitor
Based on the example, how should I use the measure to filter it by project and then compare its latest progress (based on the date) with the previous progress date?
- lbendlin2 years agoSuper User
please provide sample data in a usable format, not as a screenshot.
- FarhanFahami_2 years agoFrequent Visitor
Sure! You can get the sample data from the link below(sorry this is my first time here, im not sure if there are any best method to share the data).
https://mega.nz/file/Zbl02QhK#To7eS0_KvgWVR7TKm2mVbbVI_Br0CizQeE9ny7RUCv4
- lbendlin2 years agoSuper User
You could theoretically use a measure for this, but it might be better to have a graphical solution, for example based on Visual Calculations.
see attached.