Hello!
I would like to know if there is a way to calculate the diffrence betwenn two values that are being visually filtered.
The situation is as follows:
Currently, my dashboard is composed of two sides (left and right). I have the exact same measures being displayed on a multi row card on each side, but each side is being affected by its own filters. Meaning that I have 3 slicers on the right only interacting with the card on the right and 3 slicers on the left only interacting with the card on the left.
Just for better understanding, those slicers could be filtering YEAR, MONTH and TYPE, and the idea of this report is to compare the same measure evaluated on a specific period and category with another period and category.
My question now is: How could I have a visual (lets say on the middle) that is displaying the difference between the value on the right and the left?
Thanks for your help in advance! 🙂
