Simple Question About Drills and Visuals

[viera00]

Hello Everyone,

I've a simple question about the drill down functionlaity.

I've built a report using a column chart using diferent dimensions to drill down. The visualization works great, but the user is getting lost when drilling up and down, because there is no pleace where the visualization shows exaclty the drill step where you came from.

For example, imagine the following scenario, 

Dim 1 -> Dim 2 -> Dim 3

Imagine the user drills down into Dim 3 to review values, but if the user did not remember which value it selcted previously, he will not know in which Dim 1 , or Dim 2

I tried using Card with the values of Dim 1 and Dim 2, but when I drill into, the cards do not filter.

Has anyone faced something similar ?

Any suggestion will be appreciated.

Regards

GV

[Eric_Zhang · Accepted solution]

@viera00

No solution but a workaround to use the tooltips. Eg create a measure as below ,put the measure in tooltips and drill down. You could apply this to your Dims accordingly.

year ind = year(LASTDATE(Table3[Date]))

Actually your requirement sounds reasonable, you can submit this idea and I will surely vote it up.