Forum Discussion

PHDurand's avatar
PHDurand
Icon for Helper I rankHelper I
9 years ago
Solved

Column Chart showing all months

Hello PBI Community,   I hope someone would be able to help me with my issue. I have date slicer in my report allowing to choose a specific month/year combination (ex: April 2017). In the report I...
Reports
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    PHDurand

     

    You can use two build-in slicers instead of the custom visual HierarchySlicer. One for year and one for month. Edit year slicer so that it can only filter the column chart but not month slicer, please refer to the first screenshot. Edit month slicer so that it cannot filter the column chart and year slicer, please refer to the second screenshot.

     

     

    Best Regards,
    Herbert

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

PHDurand

 

You can use two build-in slicers instead of the custom visual HierarchySlicer. One for year and one for month. Edit year slicer so that it can only filter the column chart but not month slicer, please refer to the first screenshot. Edit month slicer so that it cannot filter the column chart and year slicer, please refer to the second screenshot.

 

 

Best Regards,
Herbert

  • PHDurand's avatar
    PHDurand
    Icon for Helper I rankHelper I
    9 years ago

    Thanks it works.