#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.