The Australian has won five of the 15 games he has taken charge of and Scotland will be looking for their second win of this year's Championship when they travel to Wales to face defending champions Cardiff.
Neither side can challenge for the title this time round with the games in Rome and Paris deciding the destiny of the trophy.
But Johnson insists there is still plenty to play for without the focus falling on his final match in charge.
"It's not about me. I did it for what I feel is the right fit for Scotland and I'll take up a different role and I'll enjoy that - but I'm really proud to say I've been a part of it," he said.
"I think the last couple of weeks have been encouraging. I go back to the first weekend against Ireland, I thought we were the dominant side then, I think we played terrific rugby.
"I think there are glimpses here. Last weekend against France we showed great resolve.
"When you concede the penalty count that we were coming on the back of and we were playing all the rugby and not losing our composure and really playing with great intent, it shows a bit about the team I think.
"I feel for the boys who couldn't finish off and we have to look at ourselves for that but sometimes the scoreboard doesn't reflect the game."
Johnson delayed his team announcement, initially naming 14 backs to choose from due to injury concerns before handing Dougie Fife his debut on the wing.
Max Evans also starts in place of the injured Sean Lamont with Fife stepping in for Tommy Seymour, who is also sidelined.
SCOTLAND SIDE TO FACE WALES
15. Stuart Hogg (Glasgow Warriors)
14. Dougie Fife (Edinburgh Rugby)
13. Alex Dunbar (Glasgow Warriors)
12. Matt Scott (Edinburgh Rugby)
11 Max Evans (Castres)
10. Duncan Weir (Glasgow Warriors)
9. Greig Laidlaw (Edinburgh Rugby)
1. Ryan Grant (Glasgow Warriors)
2. Scott Lawson (Newcastle Falcons)
3. Geoff Cross (Edinburgh Rugby)
4. Richie Gray (Castres)
5. Jim Hamilton (Montpellier)
6. Ryan Wilson (Glasgow Warriors)
7. Kelly Brown (Saracens)
8. David Denton (Edinburgh Rugby)
16. Ross Ford (Edinburgh Rugby)
17. Alasdair Dickinson (Edinburgh Rugby)
18. Euan Murray (Worcester Warriors)
19. Tim Swinson (Glasgow Warriors)
20. Alasdair Strokosch (Perpignan)
21. Chris Cusiter (Glasgow Warriors)
22. Duncan Taylor (Saracens)
23. Jack Cuthbert (Edinburgh Rugby)