Forum Discussion

Pitchaimuthu's avatar
Pitchaimuthu
Icon for Helper II rankHelper II
9 years ago
Solved

How to show the user selected drill down values on label?

I have bar charts with date hierarchy like(Year, Month, Qtr, Week and Day). So when the user drill down on particular year, that the need to show the selected drill down year on label. below my scree...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Pitchaimuthu,

    You can create a calculated column to get Year-Quarter using the formula, and use it as field in the bar visual. Then create Hierarchy. Year(first level)->Year-Quarter(second level).

    Year-Quarter=Table[Year]&"-"&Table[Quarter]


    Thanks,
    Angelia

satbirminhas's avatar
satbirminhas
Icon for Advocate II rankAdvocate II
9 years ago

If you are in the Power BI service, this problem can also be solved by following the steps listed below:

1. Select the visualization.

2. Click Format in the visulizations pane.

3. Switch off the Concatenate Labels option under x-axis. 

 

This seems to do the trick and shows the drill down value selected by the user as part of the x axis itself as a hierarchy and works for multiple drill down levels.

 

 

P.S. This might work with Power BI desktop as well but I haven't tried it. 

 

Best Regards,

Satbir Minhas