Without a data reshape, I don't thing there is a way to achieve this.
Below are the steps by union your data to itself
And recreate the view as below
As combination of your other requirements, it become more complicated, but give it a try if this is something you could do it.
I attached the workbook for your reference.
Hope this helps
In my scenario i have used custom queries and joins for pulling data. and there are multiple tables which are joined. I guess this step is not possible for my dashboard. Can you please suggest any other method.