cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver III
Resolver III

Dynamic Chart with Slicer

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

 

Country is my Slicer

 

country slicer.png

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

 

 sales by country.png

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

 

 sales by program.png

Please help

Thanks in advance

4 REPLIES 4
Highlighted
Resolver I
Resolver I

Re: Dynamic Chart with Slicer

Do you want to change the axis with slicer?

Highlighted
Community Support
Community Support

Re: Dynamic Chart with Slicer

@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.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver III
Resolver III

Re: Dynamic Chart with Slicer

I have did that but the people not happy with the option.. is there anything else that I can do that
Highlighted
Community Support
Community Support

Re: Dynamic Chart with Slicer

@chethan,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors