#MakeOverMonday Week 28 2019

In the facebook group I got feedback on iteration 2

*Loads better! I felt part of the conversation and knew immediately what story you were trying to tell! **Fantastic job! Great blog post! I hope others are encouraged to try this after seeing your journey! *

*Questions*

*Is there a legend for the first two graphs?**Do they need to be multicolored or could you make them all the same color and then call out the years you want to point out in a highlight color?*

*My answers*

- There is no legend for the first two graphs, if I give one it will be a list of 28 countries and that is a lot.
- Looking at answer 1 in combination with question 2 I’m going to make a stacked column cart with 3 layers, 26 countries together and the 2 that I’m talking about separated and than I can also make a legend for the two graphs.

**How did I do this.**

I wanted to make a measure in Power BI, where I calculate the 26 rows and do not calculate the values of Germany and Hungary. I could not get it done with a DAX formula, so I went back to the source, the excel file and made a new row with the right values and imported the file as a new file.

Who can tell me how to do it with a DAX formula?

*Suggestion*

*Another graph that might be interesting is the variance between accepted and denied which you might be able to use a waterfall chart to show in Power BI. *

I did not start working on that one yet.