Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Pie Chart based on selected value in a Slicer

Hello All,

 

My Requirement is :

 

I have a pie chart, if none of the slicers are selected, it should show me total values. If one slicer is selected, the calculation should perform a group by selected values in a column and the pie chart should get divided and if another slicer is selected it should perform group by on selected values in slier and again pie chart should get divided.' 

 

For Example: When None of the slicers are selected:

 

 

 

IF One or more  slicer value  is selected :

 

 

 

 

 

 

 

 
 

 

 

 

Similarly, if more value are selected Pie chart should be divided more 

 

NOTE: THIS IS NOTA DRILL DOWN  Fucntionallity, I need Calculation based on user slicer selection.

 

Let me know if anyone has a good approach.

 

Thanks for reading my topic.

 

Regards,

Atya

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Using isfiltered , try to create a view by/group by. and try to use that as row.

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    As tested, it's impossible to realize your idea in current version.
    (My version: 2.76.5678.782 64-bit (December 2019))

    You can submit your ideas to power-bi-ideas .

     

    And the multi-selection function of the slicer can fulfill some of your needs.

    Best regards,
    Lionel Chen

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