Forum Discussion

chethan's avatar
chethan
Resolver III
8 years ago

Dynamic Chart with Slicer

I have a data that has sales amount by country, Program, Sale Amount

 

Country is my Slicer

 

If I select the county it should have to show account wise chart

 

 

If I have not selected the country in slicer it should ideally show country wise slicer

 

 

Please help

Thanks in advance

4 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    chethan,

     

    Instead, you may drag both Country and Program to Axis, and click the second icon "Go to the next level in the hierarchy" in the top left corner of the visualization.

    • chethan's avatar
      chethan
      Resolver III
      I have did that but the people not happy with the option.. is there anything else that I can do that
      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support

        chethan,

         

        As far as I know, this is a more flexible approach, try to persuade them to accept it.