Hi Team,
I am trying to show a bar chart with drill down option and the measure would be YOY growth.
I have State, District and City as 3 dimensions and volume are measure. I have used the below expression to compute the YOY growth.
Sum({1<Year={"2020"}>}[Sellout Qty])/Sum({1<Year={"2019"}>}[Sellout Qty])-1
The issue is when is use a simple bar chart ie., 3 bar charts individually for State, District and City, the above expression works fine.
However when i try to put all the 3 dimensions in the same bar chart using drill down in master dimension, the drill down is not functioning properly. When i click on a state, all districts in the country gets displayed irrespective of the state selected. Pl help.