Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power BI slicer

Hi Experts,   I have the Power BI default slicer in my report which has multiple fields as hierarchy and of drop-down type. Fields are Calendar Quarter and Calendar month. Slicer selection control ...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Anonymous 

    From my point of view, the Slicer have to display both the [Qty] and the [Month] value you selected. It can not be set manually. If you can't accept it, You can try the List type, like this:

     

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago
The only way I know to do this would be to remove Calendar quarter from the slicer, this will also ensure that they only select one month, not a whole quarter of months.
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks AllisonKennedy  for your reply.

 

A user can either select the whole quarter or a single month. That is the reason we can not remove the Calendar quarter field from the slicer.

  • v-robertq-msft's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

    From my point of view, the Slicer have to display both the [Qty] and the [Month] value you selected. It can not be set manually. If you can't accept it, You can try the List type, like this:

     

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.