Forum Discussion

viera00's avatar
viera00
Helper II
10 years ago
Solved

Simple Question About Drills and Visuals

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

  •  

    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.

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

     

    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.