You can put "place holder" measure which is typically "Min of number of records" to put "1" always.
Then, for each "Place" you put individual indicator, color and text.
Below are the step instruction.
Change axis range to 0-3 to align the position.
Change aliases for Sales and Profit
Remove grid line.
Dynamic YOY Calculation_10.2.twbx 510.2 KB
Thank you so much for the instruction. It is very helpful. I have another two extra questions and I am wondering whether you can help me again
1. Can we adjust more space between the indicators and numbers?
Currently, I format the numbers in right/left so that the numbers and indicator has space while I am wondering whether we can adjust more space between numbers and indicators
2. Currently we have numbers, Year over Year change indicators. Can we use some way to add another column with the indicators for current month and prior month change indicator ? In another way numbers, indicator1, indicator2
1. add "space" before the number
actually, "a " and remove first "a" if space cannot be inserted directly.
2. add new KPI to horizontal view is easy.
You can modify axis to add header title like YOY Profit, YOY sales etc.
But if you want vertical more than 2 KPIs, or 2 x 2 matrix, I don't have easy idea to accomplish it with one sheet and single data..
If your data size is reasonably small, you can try duplicate data with "Union"
Or merge two sheets on dashboard.
If you really need this solution, because that way different approach, I recommend that you post another thread with clear expectation.
Thanks a lot Shinichiro. My data is very big. Currently, I am putting indicators and numbers on two sheets and floating them on the dashboards.
I probably will put another post about the N*N matrix. while I did think it is kind of complicated.
Do you think it is weird to use the two floating sheets on one dashboard to solve this problem?
Thanks so much
1 of 1 people found this helpful
I don't think it's weird when you use two sheets on dashboard, or it's even natural solution.
One concern though is aligning all the format across worksheets sometimes difficult.
Especially, if use need to scroll to see one worksheets, the function synchronizing multiple sheets when scrolling is not available.
Thanks a lot Shinichiro for your help and input. It is very helpful