Comparing data from two time points in the same visualisation??

[Anonymous]

Hell All,

I don't have a specific example, but what I am trying to do is take data from the one table and show a comparison between this week and last. So number of jobs done this week compared to last week.

So say we have three people, John, Robert and Susan, I want a graph that shows John's results from last week next to his results from this week, the same for Robert and Susan. So there would be 6 bars in total in pairs for each person.

Is any of this possible?

[Jihwan_Kim]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

All measures are in the sample pbix file with the step's number in front of each measure.

https://www.dropbox.com/s/70wwm5w8vwandqs/noblelox.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Refer

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8