Forum Discussion
YOY % Change
kalkhudary Hi, you can do it through the quick measure option (Time intelligence ==> Year over year change)
Before that, you can split your table by category. i.e. House, Condo, and Land.Below image for your reference. Quick measure time intelligence function.
Split the tables by category.
Output, hope it helps 🙂
kalkhudary Hi, it should work for the combined data as well. If it helped you achieve the desired output. Kindly mark it as an accepted solution.
You will need to apply visual-level filters when you want to see data only for one category.
Hi there
Did you get how to make it work for the combined dataset if you do not wish to have separate tables? I have the same question as yours. Thank you
If the data is in a single table, When you click on the datapoint you are now setting the filter context so that the min and max range is the same as the clicked value and it won't give you the intended result. That means you need to provide your desired min value from a different, disconnected table, which I am thinking how to do it. Will we need to create the same table query and then it works, still exploring.